Description

The Pivot Table is one of the most intuitive and powerful tools in Excel. With any list or table in your workbook, you can create a summary analysis and a chart highlighting insights in just seconds. Taking more time than that, you can build an interactive dashboard with multiple charts and filters.

Topics include:

Designing and controlling lists and tables as the Pivot Table source

Creating Pivot Tables to analyze data populations

Adding Slicers and Timelines to Pivot Tables for interactivity

Visualizing insights with Pivot Charts

Making multiple-chart dashboards