Creating advanced charts in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 11 videos | 29m 55s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 271 users Rating 4.5 of 271 users (271)
Analyze and present your Excel data in a more visually appealing way using Excel 365's various chart types. In this course, you will learn how to work with different chart types; and how to change a chart's appearance using the chart formatting tools. Next, you will learn how to edit a chart's data series and customize the chart's titles, labels, and axes. You will also see how to save a chart type or chart formatting choice as a template to make it easier to use and include in future spreadsheets. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this creating advanced charts in excel 365 course
    Create a bubble chart in excel 365
    Create a radar chart in excel 365
    Create a scatter chart in excel 365
    Create a map chart in excel 365
    Create a box and whisker chart in excel 365
  • Create a combo chart in excel 365
    Create a funnel chart in excel 365
    Create a histogram in excel 365
    Create sunburst and waterfall charts in excel 365
    Create a chart template in excel 365

IN THIS COURSE

  • 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
  • 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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.5 of 2813 users Rating 4.5 of 2813 users (2813)
Rating 4.6 of 416 users Rating 4.6 of 416 users (416)
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 378 users Rating 4.6 of 378 users (378)
Rating 4.4 of 6009 users Rating 4.4 of 6009 users (6009)
Rating 4.5 of 1501 users Rating 4.5 of 1501 users (1501)