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. 

If you are an advanced user of Pivot Tables, Power Pivot is a very useful upgrade to your skillset. Power Pivot was built as a component of Power BI, but Microsoft added it to Excel using an Add-in. With it, you can create relationships between data tables, and add new DAX functions to existing analyses.

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
• Using the Excel Data Model in Pivot Tables
• Writing DAX functions for use in summaries