Microsoft Excel 8: Power Pivot and Modern Excel - Hands-on
Microsoft Excel 8: Power Pivot and Modern Excel
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