Working with advanced charts in Excel 365 (2024)

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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). In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane.