Creating advanced charts in Excel 365

IN THIS COURSE

• 1.  Overview: Creating advanced charts in Excel 365
  41s
  This video outlines the key content covered in this Microsoft 365: Creating advanced charts in Excel 365 course, including how to create and insert various chart types, edit a chart’s data series, and how to save a chart as a template and use it on other data tables. FREE ACCESS
• 2.  Creating a bubble chart
  3m 49s
  In Excel 365, a bubble chart can be used to cross-reference three different types of information in a single chart. Different data values can be visualized according to where the point is placed on the x- and y-axes and the size of the point itself. In this video, you will explore how to create a bubble chart in Excel 365. FREE ACCESS
• 3.  Creating a radar chart
  2m 52s
  A radar chart can be used to visually plot five different data values in a single chart, with each axis representing a particular value or measurement. Once a radar chart is inserted, you can compare the form and size of the shape created along the five different axes to obtain an overall representation of the respective data series. In this video, you will explore how to create a radar chart in Excel 365. FREE ACCESS
• 4.  Creating a scatter chart
  4m 9s
  In Excel 365, a scatter chart can be used to cross-reference values and combine different data types to make it easier to analyze or interpret information that originates from different data series. In this video, you will explore how to create a scatter chart in Excel 365. FREE ACCESS
• 5.  Creating a map chart
  2m 6s
  Map charts in Excel 365 are useful to plot geographical values such as when you have data relating to regions, countries, or region-specific locations. In this video, you will explore how to create a map chart in Excel 365. This video aligns with the MOS MO-201 / Excel Expert Certification exam objective: 4.1.2 Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts. FREE ACCESS
• 6.  Creating a box and whisker chart
  3m 6s
  In Excel 365, you can create a box and whisker chart to represent a statistical distribution of data values visually, including the upper and lower range of observations or "boxes," and any outlying points that don't follow a trend, the so-called "whiskers." In this video, you will explore how to create a box and whisker chart in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 4.1.2 Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts. FREE ACCESS
• 7.  Creating a combo chart
  2m 9s
  Any data that's arranged in columns and rows in Excel 365 can be plotted in a combo chart, which combines two or more chart types with the alternative for a secondary axis to make the data easier to interpret, especially if the data is quite diverse. In this video, you will explore how to create a combo chart in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 4.1.2 Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts. As well as MOS MO-201 / Excel Expert Certification exam objective: 4.1.1 Create and modify dual-axis charts. FREE ACCESS
• 8.  Creating a funnel chart
  1m 59s
  Funnel charts are ideal to portray values across multiple stages of a process. Typically, the chart values decrease gradually over time, giving the overall appearance of the chart a funnel shape. In this video, you will explore how to create a funnel chart in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 4.1.2 Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts. FREE ACCESS
• 9.  Creating a histogram
  3m 19s
  In Excel 365, you can create a histogram, which is a type of statistical column chart used to depict the frequency of data values at intervals. In this video, you will explore how to create a histogram in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 4.1.2 Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts. FREE ACCESS
• 10.  Creating sunburst and waterfall charts
  3m 24s
  A sunburst chart offers a hierarchical representation of data, whereas a waterfall chart is used to depict how a series of positive or negative values affect a whole, such as a running total. In this video, you will explore how to create sunburst and waterfall charts in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 4.1.2 Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts. FREE ACCESS
• 11.  Creating a chart template
  2m 21s
  Chart templates help make it easier to generate charts in Excel 365, especially if there is a specific chart format that you use often that you'd like to save. In this video, you will explore how to create a chart template in Excel 365. FREE ACCESS