Chapter 44. The Data Model

Questions answered in this chapter:

  • What is the Data Model feature and why do I need to learn about it?

  • How can I add data to the Data Model?

  • How can I create relationships within the Data Model?

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

  • How does the Quick Explore option work?

  • How can I add new data to a Data Model?

  • How can I remove data from the Data Model?

  • How can I use the Data Model to create a new PivotTable?

  • How can I edit or delete relationships?

  • How does the DISTINCT COUNT function work?

Answers to this chapter’s questions

This section provides the answers to the questions that are listed at the beginning of the chapter.

What is the Data Model feature and why do I need to learn about it?

The Data Model feature is ...

Get Microsoft Excel 2013: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.