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!