Create a Data Model from External Relational Data in Excel: Overview You can create a data model from external relational data in Excel. Data models in Excel let you store multiple tables of information. They can then be used a data source for PivotTables, PivotCharts, and Power View reports. The choice to add
Data Visualizations in Power View in Excel: Overview You can visualize report data in a Power View worksheet by adding data visualizations in Power View in Excel. To add data visualizations in Power View in Excel, drag a data field from the “Power View Field” task pane into the “Fields” section of the task
Add Excel Tables to a Data Model in Excel 2016: Overview You can manually add Excel tables to a data model in Excel 2016 or earlier workbooks. You can then use them as the data source for PivotTables and PivotCharts. Note that this process has changed in Excel 2019 and Excel for Office 365.
Microsoft Office 2016 Released 9-22-15: Product Information Microsoft Office 2016 has been released to the public as of 9/22/15. This means that Office 2016 is now available for both Windows and OSX operating systems. It is also available for all Office 365 subscribers. Users of Office 365 can install the latest Office 2016