Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Pivot Tables built with Power Pivot and the Data Model are the future of Excel reporting. This course explores the concept of a DATA MODEL that is built into Excel since version 2013 and how it makes Pivot Tables so much more powerful. The course introduces the powerful POWER PIVOT capability and how Power Pivot can construct a complex data model. It also includes the new features that Pivot Tables will gain when used with the Data Model and Power Pivot.
KEY TAKEAWAYS:
By the end of this course, participants will be able to:
- Construct Pivot Tables from a Data Model
- Use special features of Pivot Tables constructed from a Data Model
- Combine data sets into a useful Data Model through Power Pivot
- Pull data from multiple tables into one Pivot Table
- Understand the rules of building relationships between tables of data
- Gain an understanding of Power Pivot and core concepts as a springboard to advanced techniques
WHO WILL BENEFIT:
Anyone who works with multiple data sets and data sources and needs to build Pivot Tables and complex reports by combining all these data sets into coherent and error-free reports. Suitable for anyone who has a working knowledge of Pivot Tables.
Unlock learning anytime, anywhere with the Blackboard Learn app
Seamlessly access your on demand courses, assignments, and get PD hours on the go. Learn how to download now and elevate your education experience with the convenience of mobile learning.
How to Access The Course
This is an online session. This course is available 24 hours a day, 7 days a week. Once registered, you can access the material at any time.
However, you will only have access to the course for 90 days after REGISTRATION.
New mobile learning! Download Blackboard Learn from your app store (iOS or Android). Learn more.
To access the course on your computer please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.
Please allow up to 15 minutes after registration for the course to appear on your BlackBoard page.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Paul Mascarenhas, BSc., MBA is a specialist in Strategic Analysis and Communications. He has developed and conducted Information Technology workshops for leading corporations, institutions and government in Canada and internationally for 15 years. Paul loves the outdoors, is an avid angler and holds a Canadian Recreational Pilot’s permit.