With Power Pivot, your PivotTable reports can become even more powerful than you might have thought possible. This amazing tool can connect directly to many common external data sources to link data directly into your reports. Alternatively, you can use it in conjunction with Power Query for superior data import and transformation capabilities.

DAX functions allow you to create sophisticated calculations in your PivotTables, adding even more analytical capabilities. The relational functionality of Power Pivot provides all the tools necessary for creating an intermediary database from multiple data sources.

Fundamental knowledge of computer operations and Microsoft Office Excel, including creating PivotTables is recommended.

Applicable For
Accountants and business professionals who are seeking to improve financial analysis processes by taking advantage of the Power Pivot feature found in Windows-based versions of Excel

Content
Upon completing this course, you should be able to:

Differentiate between ordinary PivotTables and those created with Power Pivot
Identify the advantages of working with Power Pivot
Explain the procedure for building a PivotTable using Power Pivot
Define Data Models, Data Analysis Expressions, and Key Performance Indicators

What to Expect

Upon completing the registration process, you will receive an email from the provider within two business days confirming your registration along with instructions on how to join. Registrants can come and go from the course as often as they like.


A test with 5 questions per hour and a 70% pass rate is required to confirm attendance.

How Do I Connect?

Follow the steps outlined in the provider email to join the training session.

If you are having any technical issues during the session, please view the Help resources, where you will find technical support for the most common questions. If you need additional assistance, please call 1 985.542.9390 or send an email to [email protected].

CPA Manitoba PD Terms and Conditions