Learn what Excel’s Data Model is and why it’s a game-changer for working with multiple tables and large datasets! In this tutorial, I’ll show you everything you need to know about Excel’s hidden data storage feature. What You’ll Learn:
- What the Excel Data Model is
- Why you’d want to use the Data Model
- How to access and view data in the Data Model using Power Pivot
- Three different methods to get your data into the Data Model
- How to create Pivot Tables using data from multiple tables
- How to handle large datasets that exceed worksheet row limits
- How to update and refresh Data Model data
Important Note: The Data Model is only fully supported in Excel for Windows. Mac and web versions have limitations.
Download a copy of the file(s) used in this video: https://share.zight.com/2NuD9KWE