Sign in to confirm you’re not a bot
This helps protect our community. Learn more

How To Build PivotTables Using Excel's Data Model Feature

K2 Enterprises
5.08K subscribers
<__slot-el>
<__slot-el>
14K views 11 years ago
Added to the 2013 release of Excel, the Data Model feature allows you to relate multiple Excel tables together and then build PivotTables from the related tables. Using this approach, you can effectively build a PivotTable from multiple Excel-based data sources, as long as you maintain those sources as tables. In this tip, you will learn just how easy it is to build a PivotTable using Excel's Data Model feature. ...more
...more
How To Build PivotTables Using Excel's Data Model Feature
39Likes
14,034Views
2014May 14
Added to the 2013 release of Excel, the Data Model feature allows you to relate multiple Excel tables together and then build PivotTables from the related tables. Using this approach, you can effectively build a PivotTable from multiple Excel-based data sources, as long as you maintain those sources as tables. In this tip, you will learn just how easy it is to build a PivotTable using Excel's Data Model feature.

Follow along using the transcript.

K2 Enterprises

5.08K subscribers