My Profile
My Events
My Self-Study
My CPE Tracker
My Discounts
Member Directory
Upcoming Events
Communication Preferences
My Committees
My Transactions
My Dues
Online Store

Help

Sessions | Instructor | Event Registration |

Event Information

K2's Mastering the Excel Data Model Webcast | 4203619B
Date: August 14, 2020
Event Start time: 10:00 AM   End time: 11:40 AM
Location: Webcast

Facility: Webcast Rebroadcast

 


Member:       $79
Nonmember: $109

CPE Credits:

2.00 CPE: Continuing Professional Education Technical


 

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 Power Pivot. With the Data Model, users can 1) relate multiple Excel tables, 2) build PivotTables on multiple data sources, 3) import data from external data sources, and 4) analyze PivotTable reports using Quick Explore, which allows users to drill up, down, and around in reports. This session will provide the knowledge and skill necessary to take full advantage of the Excel Data Model.

 

Objectives:
 

*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

 

 

Major Subjects:
 

*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

 

 

Level of Difficulty:
Intermediate

Field of Interest:
Computer Software and Applications

Prerequisites:
 

Good working knowledge of Excel

 

Designed For:
 

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

 

Advanced Prep:
 

 None

 

Event Notes:
Save with Discount Programs

Join or Renew Today