Chapter 46 The Data Model
Questions answered in this chapter:
What is the Data Model, and why do I need to learn about it?
How do I add data to the Data Model?
How do I remove data from a Data Model?
How do I create relationships within the Data Model?
How do I use the Data Model to create pivot tables?
How do I add new data to a Data Model?
How can I use the Data Model to create a new pivot table?
How do I edit or delete relationships?
How does the DISTINCT COUNT function work?
Answers to this chapter’s questions
What is the Data Model, and why do I need to learn about it?
The Data Model feature was added in Excel 2013. (Originally, the Data Model was an add-in for Excel 2010.) The Data Model provides an easy way to load data beyond the ordinary ...
Get Microsoft Excel 2019 Data Analysis and Business Modeling, 6th 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.
