2020 - Excel: Building a Reporting Tool with Pivot Tables and Charts

Use cases: Why and when you should use a Pivot Table
Your raw data - do’s and don’ts
Create a simple Pivot Table with a few mouse clicks
Different ways to summarize your data - total, count and percent
Apply formatting to a Pivot Table to make it easy to read and understand
Display Pivot Table data in alphabetical or numerical order
Represent the Pivot Table data as a chart/graph
How to update a Pivot Table when the source data changes