Advanced Excel Power Tools – Introduction to Power Pivot and the Data Model (2 hrs) -2 pm Halifax, 1 pm Toronto, 11 am Calgary, 10 am Vancouver

Course No: RHWE-1419

Format: HANDS-ON ONLINE WORKSHOP. This is a Live Workshop with an Instructor. Participants will work hands-on on practice data, and interact with an instructor online.

Duration: 2 Hours in 1 module of 2 hours. Participants will work on examples hands-on with the instructor

PRICE & BOOKING: Individual Registrations @ $100 per person. Corporate or Group booking of 3 or more persons will receive a discount. Contact us

This Course will cover:

  • Revisiting a key feature – the Dynamic Table – how it fits in with Power Tools in Excel
  • What is the Data Model and why is it important for Pivot Tables?
                • What does it mean in terms of spreadsheet data?
                • How do you take regular spreadsheet data and add them to the Data Model?
  • What is the Power Pivot Add-in and how to enable it.
  • Working with the Data Model using Power Pivot
                • Examine the data view and diagram view.
                • Build data relationships between tables.
  • Explore some additional features in Power Pivot like Calendar or Date Tables
  • Create Pivot Tables that use multiple data tables and explore some powerful features that become available.
  • Tips and Tricks to handle special scenarios

Important Instructions:
• Office 365 will be used in the workshop demonstration. Participants are welcome to use older versions, but significant differences may exist and where possible the instructor will mention suitable workarounds.

• IMPORTANT: This workshop needs AT LEAST Excel 2013 or later, with Power Pivot available in Excel. If you do not have Power Pivot you will be able to observe but will not be able to practice along with the instructor. If you have Power Pivot installed AND version 2013 or later, you will be able to complete all the examples. **You may have Power Pivot but it may not be enabled and not visible on your Excel Menu. See this page “Where is Power Pivot” on for more information**

• Essential requirements are a Computer with broadband internet access, audio headset or speakers, and working copy of Microsoft Office. Microsoft Office Starter Edition will not be adequate.


The event is finished.


Apr 05 2024


1:00 pm - 3:00 pm




    Course Title Start Date

    Your Name (include lastname)Your Email
    City Province/State Country

    I would like to register for

    To register please also read these Terms and ConditionsI agree

    How your Privacy is protected

    • All webcams are disabled by default and only you can enable your webcam.
    • You have the choice to send questions or messages in private to the instructor, or publicly to all participants. If you ask a question privately the instructor will answer without identifying the person who asked the question
    • We don't use email addresses for marketing purposes. We use it only to communicate with you regarding your login credentials, course materials, and any other emails that you request.

    Free Video Resources on our YouTube Channel

    Free Excel Quick Reference Card

    Download this handy quick reference card of Keyboard Shortcuts and Commonly used functions

    Free Video Resources on our YouTube Channel

    April 2024
    No event found!