Data Model Walkthrough CalCPA Article

Jeff Lenning|July 17, 2018||Data Model, PivotTable, Power Pivot

Have you heard people talking about Power Pivot and the data model, but you aren’t exactly sure what they are or how to use them? Well, in this article, we’ll use them to build a basic PivotTable. Workbooks used to summarize exported data can potentially be improved by using Power Pivot and the Data Model. Check it out by clicking the title below.

http://www.excel-university.com/articles/cal-cpa/data-model-walkthrough/

Posted in Add-Ins, Excel, Features

Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

Excel is not what it used to be.

You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.

Free Roadmap

Want to learn Excel?

Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.

Training Info