Interactive
Preparing Data and Creating Pivot Tables in Excel 2016: Create a PivotTable From an External Data Sources
BizLibrary
Updated Feb 05, 2019Microsoft Office Excel 2016: Part 4 (Data Analysis with PivotTables) - You won't always have source data in Excel ready to create a PivotTable. Many times, your source data is stored outside of Excel. Fortunately, Excel provides a way to create PivotTables from data sources outside of Excel. (Limitations of Excel as a Database, External Data Sources, the Select Data Source Window, the Import Data Dialog Box)
Related learning
