Advanced Excel Power Tools – Introduction to Power Pivot and the Data Model (2 hrs) -1 pm Halifax, 12 pm Toronto, 10 am Calgary, 9 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 Microsoft.com 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.