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.
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.