Using the Data Model to Create PivotTables (1-Hour Recorded Webinar)
This recorded live webinar will walk you through creating PivotTables in Excel using the Data Model.
Our Excel expert trainer, Deb Ashby, will first teach you what a data model is all about. She will also discuss the Power Query editor, how to add data to the data model, and how to create a PivotTable and Pivot Chart from the data model.
Deb covers the following:
- What is the Data Model and why do we use it?
- Example of a basic PivotTable report
- Understanding the data files
- How to get and transform data from a folder
- The Power Query editor
- Combining multiple files
- Adding data to the data model
- Creating relationships between tables
- Creating a consolidated PivotTable
- Creating a Pivot Chart from the data model
- Updating data
Watch the session here, and download the instructor demo files to follow along.
Using the Data Model to Create PivotTables – Recorded Webinar
Download the instructor files and follow along.
Other Microsoft Webinars:
Getting to Grips with PivotTables in Excel (1-Hour Recorded Webinar)
Advanced Formulas in Excel (1-Hour Recorded Webinar)
Get the Most Out of Microsoft Teams (1 Hour Recorded Webinar)
Please visit our free Microsoft Office resources center for more high-quality Microsoft guides.
Simon Calder
Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA.He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!
