Description

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:

• Converting existing lists into Excel Tables
• Creating relationships between tables
• Using the Excel Data Model in Pivot Tables
• Writing DAX functions for use in summaries