All 2020 CPE and networking events have been moved online. Visit our updated catalog »

Webinar(CA): K2’s Mastering the Excel Data Model

Description

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.

Learning 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 Topics

*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

Provider
California CPA Education Foundation
Course Level
Intermediate
CPE Field of Study
Computer Software and Applications
2
Who Should Attend

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

Instructor(s)
Tom Stevenson
Prerequisites

Good working knowledge of Excel

Advanced Preparation

None

Location
Webinar
Event Information
When
Jun 4, 2020
11:00 am - 12:40 pm MST
Location
Webinar
Total CPE Credits
2
Format
Webinar

MEMBER


$ (% off)
$75.00

NON-MEMBER


$ (% off)
$101.00
Become A Member

Register for this Event

Webinar(CA): K2’s Mastering the Excel Data Model


Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×