Advanced Excel Power Tools – Power Pivot and the Data Model (3 hrs) -12 pm Halifax, 11 am Toronto, 9 am Calgary, 8 am Vancouver

Course No: RHWE-1419-3

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: 3 Hours in 1 module of 2 hours. Participants will work on examples hands-on with the instructor

PRICE & BOOKING: Individual Registrations @ $180 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.
• Using Power Pivot to manage the Data Model
  • • • • • • • Examine the data view and diagram view.
              • Build data relationships between tables.
• Using Power Pivot to create Calendar or Date Tables
• Modifying Schema and relationships in the Data Model
• Create Pivot Tables that use multiple data tables and explore some powerful features that become available.
• Introduction to Measures (like Calculated Fields) in Power Pivot
• Introduction to DAX (Data Analysis Expressions) Functions and learning some new DAX functions
• Additional Tips and Tricks depending on time available

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.