Preparing Data and Creating Pivot Tables in Excel 2016: Create a PivotTable From Multiple Local Data Sources
Interactive

Preparing Data and Creating Pivot Tables in Excel 2016: Create a PivotTable From Multiple Local Data Sources

BizLibrary
Updated Feb 05, 2019
Microsoft Office Excel 2016: Part 4 (Data Analysis with PivotTables) - Often you have data in multiple spreadsheets that you'd like to summarize. In this topic, you will create a PivotTable from multiple local data sources. (the Excel 2016 Data Model, Named Tables, the Create Relationship Dialog Box, the Manage Relationships Dialog Box)
;