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 Highlights
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.
Registration
PICPA Member: $75 Nonmember: $101
More Information
Course No.
4203619B
Level:
Intermediate
Prerequisites:
Good working knowledge of Excel
Notes
None
Speaker(s)
Thomas Stephens
K2 Enterprises
Thomas G. Stephens, Jr.,
CPA.CITP
Bachelor of Science in Business Administration, Major in
Accounting,AuburnUniversity
Master
of Science, Major in Finance (emphasis in Corporate Finance), GeorgiaStateUniversity
Twenty-five
Years of Public Accounting Experience, Five Years of Corporate Internal
Auditing Experience, Four Years of Corporate and Cost Accounting Experience
Nineteen
Years of Experience as a Continuing Professional Education Discussion
Leader
Member
of the American Institute of Certified Public Accountants and the Georgia
Society of Certified Public Accountants; Past Member of the Institute of
Internal Auditors
To
Date, Has Presented Over 1,800 Continuing Education Sessions to Over 55,000
Participants