Microsoft Excel 2016 Data Analysis and Power Tools Part 2 Training in Canada

• Please note that this course is not suitable for new Excel users
• Attendance on QA's Data Analysis and Power Tools Part 1 course (QAEX16PT1) or equivalent knowledge
• Have experience of importing data and working with the Data Model and Relationships
• Be able to create formulas using standard aggregate functions

Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.

• Create PivotTables and analyse data
• Connect to and shape external data using Power Query
• Use PowerPivot for data connection and analysis
• Use Power Map to create visualisations of geo-data

Lesson 1: Create and Work with PivotTables

• PivotTables Overview
• Creating PivotTables from Tables and Single Data Sources
• Working with PivotTables to Create Views and Analysis
• Dynamic Filters with Slicers and Timelines
• Use the Data Model to Create PivotTables from Relational and External Sources
• Create and Use Calculated Items, Fields and Sets

Lesson 2: Introduction to Power Query for Excel

• What is Power Query?
• Power Query Data Sources
• Data Import Process and Query Editor Overview
• Data Transforms using the Query Editor
• Editing Queries and Query Steps
• Combining Data Sources as a Mash Up

Lesson 3: Using PowerPivot

• Concepts and Components
• Working with the Manage Console
• Connecting Data to PowerPivot
• Creating and Editing Data Relationships
• Calculated Items, Measures and KPIs
• Creating PivotTables
• Dashboards using PowerPivot

Lesson 4: Visualising Data with Power Map

• Overview of Power Map
• What is Geo-Data?
• Creating Maps and Applying Options
• Tours and Scenes in Power Map
• Exporting Maps to Other Applications