Working with advanced charts in Excel 365 (2024)
Excel 365 (2024)
| Intermediate
- 9 videos | 40m 7s
- Includes Assessment
- Earns a Badge
- CPE
For individuals working with large data sets, the ability to display data clearly and efficiently is a crucial step in data analysis. This Excel 365 course offers a comprehensive review of various chart types available to improve data visualization skills. Discover how to create pie charts, focusing on the effective depiction of data proportions. Learn to summarize statistical distributions across data sets by creating and formatting box and whisker charts. To represent different data types within a single visual framework, learn how to prepare your data for creating combo charts and customize chart axes for precise and insightful data interpretation. Additionally, the course includes instruction on creating funnel charts, which are useful for illustrating process progressions, and generating histograms that help reveal frequency distributions and data patterns. The use of sunburst and waterfall charts is also thoroughly explored, offering techniques for visualizing hierarchical information and sequential data changes, respectively. Lastly, learn how to create chart templates, which can standardize the chart-making process to improve efficiency and consistency. This course aligns with the objectives of Exam MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this working with advanced charts in excel 365 (2024) course
Insert and format a pie chart
Create and format a box and whisker chart
Use the combo chart to combine two types of charts
Add and customize chart axes -
Create and modify a funnel chart
Create and modify a histogram chart
Create sunburst and waterfall charts
Create and save a chart as a template
IN THIS COURSE
-
59sThis video outlines the key content covered in this Working with advanced charts in Excel 365 (2024), including creating a box and whisker chart, customizing axes chart, and creating chart templates. FREE ACCESS
-
5m 38sA pie chart is an effective tool for comparing the varying proportions that make up an overall total, particularly when dealing with percentage data in Excel 365. In this video, learn how to create and edit a pie chart in Excel. FREE ACCESS
-
3. Creating a box and whisker chart in Excel 3654m 56sIn Excel 365, a box and whisker chart is useful for visually representing the statistical distribution of data values. This includes the upper and lower range of observations, or "boxes", as well as any outlying points that don't follow the trend, which are the so-called "whiskers". This video aligns with the MO-211 Microsoft Excel Expert Exam objective: Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Sunburst, and Waterfall charts. FREE ACCESS
-
4. Creating a combo chart in Excel 3654m 39sAny data arranged in columns and rows in Excel 365 can be plotted in a combo chart, which combines two or more chart types and offers the option for a secondary axis to make diverse data easier to interpret. In this video, explore how to create a combo chart in Excel. This video aligns with the MO-211 Microsoft Excel Expert Exam objective: Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Sunburst, and Waterfall charts. FREE ACCESS
-
5. Customizing chart axes in Excel 3654m 34sChart axes quantify the information presented in Excel 365. Learn to adjust the measurements, move the maximum and minimum values, and change where the two axes cross in the chart. In this video, explore how to modify the chart axis in Excel. This video aligns with the MO-211 Microsoft Excel Expert Exam objective: Create and modify dual axis charts. FREE ACCESS
-
6. Creating a funnel chart in Excel 3655m 7sFunnel 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, explore how to create a funnel chart in Excel 365. This video aligns with the MO-211 Microsoft Excel Expert Exam objective: Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Sunburst, and Waterfall charts. FREE ACCESS
-
7. Creating a histogram in Excel 3654m 55sA histogram is a type of statistical column chart used to represent the frequency of data values within intervals. In this video, you will learn how to create and modify a histogram chart in Excel 365. This video aligns with the MO-211 Microsoft Excel Expert Exam objective: Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Sunburst, and Waterfall charts. FREE ACCESS
-
8. Creating sunburst and waterfall charts in Excel 3655m 10sA sunburst chart provides a hierarchical representation of data, while a waterfall chart is used to depict how a series of positive or negative values affect a total, such as a running total. In this video, we will explore how to create both sunburst and waterfall charts in Excel 365. This video aligns with the MO-211 Microsoft Excel Expert Exam objective: Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Sunburst, and Waterfall charts. FREE ACCESS
-
9. Creating a chart template in Excel 3654m 9sChart templates help make it easier to generate charts in Excel 365, especially if there is a specific chart format that is often used. In this video, explore how to save a chart as a template and how to find chart templates 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.
