Excel 2016 Creating Interactive Reports with PivotCharts

 One Hour
Delivery Methods

This course is designed to teach students everything they need to know about PivotCharts to use them effectively with their data. Students will learn about how PivotCharts work, as well as how to create, modify, filter, and format them to easily visualize and analyze interactive data.


Upcoming Class Dates and Times

Mar 04, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
Apr 19, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
Jun 15, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led

Who Should Attend

This course assumes a reasonable amount of comfort working with PivotTables, so it is recommended that students learn and practice with PivotTables first because this course does not cover the basics of working with them. The ability to quickly visualize data is great skill for any student to have, however, so anyone who needs to present data is encouraged to attend.

Course Objectives

    The goal of this course is to help students visualize data efficiently and effectively. In addition to creating PivotCharts, you will learn how to modify, format, and filter them to make data look professional and easy to interpret. By the end of these lessons, you will be comfortable working with PivotTools and will have the tools you need to work with regular charts as well.


1 - Lessons
  • Analyzing with PivotCharts - Learn what a PivotChart is and how to create one from a dataset.
  • Modifying a PivotChart - Learn how to select, edit, and filter the data to visualize in a PivotChart by arranging data fields.
  • Formatting a PivotChart - Learn how to change the chart type and style and how to add and format chart elements.
  • Filtering with Slicers and Timeline Slicers - Learn how to quickly and easily filter data by creating slicers.