Introduction to Excel Data Model

Introduction to Excel Data Model
K2E Canada Inc. presents a broad curriculum of technology-focused on-demand webinars. Participants who take these webinars will have the opportunity to learn from an award-winning team of instructors with literally hundreds of years of experience in helping professionals identify, address, and solve issues through the practical application of technology. Webinars address a variety of topics, including Excel, QuickBooks, PDFs, accounting solutions, and Microsoft Office.



NOTE: Course login details are normally sent to registrants within one week from date of registration.

KE22230281

The Excel Data Model is an in-memory multi-dimensional (OLAP) data engine available in all versions of Excel 2013 and 2016. The Data Model is the core foundation of PowerPivot, but all users can take advantage of the added power of the Data Model without this premium add-in available in Office Professional Plus and the standalone version of Excel. With the Data Model, users can 1) relate multiple Excel tables, build PivotTables on multiple Excel tables, and 3) analyze PivotTable reports using Quick Explore, which allows users to drill up, down, and around in reports. This webinar will provide the knowledge and skill necessary to take full advantage of the Excel Data Model.

CONTENT 

  • Adding data to the Data Model
  • Building PivotTables from multiple related Tables
  • Using Quick Explore to drill up, down, and around in PivotTables built on the Excel Data Model
  • Calculating date fields in Tables to overcome Data Model limitations

LEARNING OBJECTIVES
Upon completing this session, you should be able to:

  • Describe the Excel Data Model
  • List the advantages of using the Data Model as a PivotTable data source
  • Create PivotTables from data stored in multiple related Tables
  • Describe the process of relating Tables in Excel 2013 and 2016

PREREQUISITE
Good working knowledge of Excel
Program Level: Intermediate
Advance Preparation: None 

WHO WILL BENEFIT
Accountants and finance professionals who want to put the power of the Excel Data Model to use right away.

CPD: 2 Hours
When
4/1/2022 - 3/31/2023 11:59 PM
Where
On-demand