Microsoft Excel: Data Visualization - Tables, Slicers, and Charts

Course Overview

Learn the skill of storytelling through data in this training, Data Visualization in Excel: Tables, Slicers, and Charts. Explore how to create impactful visual narratives that effectively communicate complex information, making it accessible and compelling to your audience.

Start by creating and manipulating column and pie charts, which are essential for presenting comparisons and proportions in an easily digestible format. As you progress, discover how to enhance data interaction through slicers and gain proficiency in using sparklines to depict trends compactly. The course also covers the strategic use of pivot tables to summarize large data sets quickly and efficiently. Toward the end, you will integrate these elements into constructing a simple dashboard.

By participating, you will develop the skills to transform raw data into compelling visual stories that can significantly influence decision-making processes. This expertise will increase your efficiency and enhance your presentation reports.

Learning Objectives:

In this course, you will learn how to:

  • Construct and format column charts and pie charts in Excel.
  • Utilize slicers to filter data across multiple tables dynamically.
  • Analyze and summarize data efficiently using pivot tables.
  • Design a basic dashboard integrating charts, slicers, and pivot tables.