Creating advanced charts in Excel 365

Excel    |    Intermediate
• 11 videos | 29m 55s
• Includes Assessment
• Earns a Badge
• CPE
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

• 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.
• 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.
• 3.  Creating a radar chart
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.
• 4.  Creating a scatter chart
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.
• 5.  Creating a map chart
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.
• 6.  Creating a box and whisker chart
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.
• 7.  Creating a combo chart
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.
• 8.  Creating a funnel chart
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.
• 9.  Creating a histogram
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.
• 10.  Creating sunburst and waterfall charts
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.
• 11.  Creating a chart template
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.

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 3.9 of 21 users (21)
Rating 4.5 of 380 users (380)
Rating 4.5 of 27 users (27)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

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