If you are a CPA Alberta member, or have a CPA Alberta account, please login with your account information.

If you are a non-member and do not already have an account, please create an account.

Forgot your account number or password?

Need help registering for a seminar? See our How to Register instructions.


Centennial 2010
  • Location:


Level: Advanced
Competency: Information Technology
Seminar Code: 01739
Format: Webinar 2 Hours
CPD Hours: 2
Availability: Online Registration is now Closed

Register before Mar 21, 2018 and pay the early fee!
Date: Wednesday, Mar 28, 2018
Time: 11:00 AM-1:00 PM

Meeting Room:
Fee Options: Tickets Required: N/A
(Passport Tickets can only by used 14 days prior to seminar start date)
Fee Required: N/A - Early Member
N/A - Early Non-Member
$79.00 - Regular Member
$79.00 - Regular Non-Member
Seminar Description: These webinars are delivered by K2E which is an American based company. Please note some US based content and examples will be used during this webinar.

PowerPivot provides unparalleled options for analyzing data and preparing summary reports in Excel. With PowerPivot, available in Microsoft Office Professional Plus or the standalone version of Excel, your PivotTable reports become even more powerful. PowerPivot can connect directly to a large number of common external data sources or can be used in conjunction with Power Query for superior data import and transformation capability. DAX functions allow users to create sophisticated calculations, both columns and measures, and the relational functionality of PowerPivot provides all the tools necessary for creating an intermediary database from multiple data sources. Put PowerPivot to use immediately by participating in this very practical session, which is sure to help you improve your analytical and reporting processes.

The participant must be logged in during the live webinar and participate when prompted. Failure to participate and respond to the prompts will result in no credit earned for the seminar as attendance will be monitored and recorded. Recordings of a live webinar will not be available after it has concluded.
Seminar Outline:
  • Differentiate between ordinary PivotTables and those created with PowerPivot
  • Describe the advantages of working with PowerPivot
  • Explain, at a high-level, the procedure for building a PivotTable using PowerPivot
  • Define Data Models, Data Analysis Expressions, and Key Performance Indicators
  • Create reports from data summarized using PowerPivot
Who Will Benefit: Accountants and finance professionals who want to streamline and improve their data analysis and reporting processes
Seminar Leader(s): YOSS, Steve
Special Notes: These webinars are delivered by K2E which is an American based company. Please note some US based content and examples will be used during this webinar. Login credentials will be emailed 2 – 5 business days before a live webinar starts. Cancellation of registrations and transfers received less than ten (10) business days, and more than five (5) business days before the Live Webinar will be subject to a $50 + GST fee which must be paid prior to the transaction being completed. Refunds will not be granted if the request is received five (5) business days or less before the Live Webinar begins.
Additional Offerings:
Can't make it to this session? See the other offerings of this seminar.

Terms and Conditions