Working with advanced charts in Excel 365 (2024)





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.


0.67

Working with advanced charts in Excel 365 (2024)

  • 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


    • ds_m365ex_19_enus