Chapter 39

The Data Model

Questions answered in this chapter:

  • How do I add data to the Data Model?

  • How do I create relationships within the Data Model?

  • How do I use the Data Model to create PivotTables?

  • How do I add new data to the Data Model?

  • How do I edit, deactivate, or delete a relationship?

  • How does the DISTINCT COUNT function work?

The Excel Data Model feature provides an easy way to load data beyond the ordinary capabilities of Office 365 (1,048,576 rows of data) and use this data to create PivotTables. The Data Model also enables you to combine data that comes from sources outside Excel (including databases like Access and SQL Server, websites, text files, and so on) with data from Excel. Finally, understanding the Data Model will ...

Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial