Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.
Excel 2: Data Modeling in Excel
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