Excel 2016 Creating Interactive Reports with PivotCharts

Course Overview

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.

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.

Course Outline

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.

Price: $49.95

Class times are listed Eastern time.

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Cart When Time Where How
10/22/2020 9:00AM - 10:00AM Online LIVE LNL
10/23/2020 4:00PM - 5:00PM Online LIVE LNL
11/19/2020 11:00AM - 12:00PM Online LIVE LNL
12/21/2020 4:00PM - 5:00PM Online LIVE LNL

Class times are listed Eastern time

This class is part of our LearnNow Pass. Click here for more details.