Excel Power Query
Delivered Face to Face or Virtually
Who should attend?
Excel Power Query will allow you to transform the way you work with data. This will reduce the amount of Macros that need to be created and will show you how to shave hours off your day with practical examples, tips, and tricks. By the end of the course, you will be an expert at cleaning, transforming and reshaping your data so that it is ready to analyse.
Prerequisites
This course is perfect for existing users of Excel who spend a lot of time manually preparing data for analysis. Previous experience of Pivot Tables and Formulas would be needed
This course can be customised to incorporate other features of Office 365.
To find out more about our training options or to find out whether this course is right for you, please speak to our team today.
Course Duration
1 Day Classroom Training or Online.
Our course timings are 09:30 - 16:30, however timings can be customised to meet your needs.
Getting Started
Introduction to Power Query
Power Query User Interface – A Walkthrough
Importing Data Rules and Best Practice
Data Preparation - Part 1
Combine or Merge Multiple Files from a Folder
Importing Data from the Web
Merge Queries vs. Append Queries
JOIN Types for Beginners
Understanding JOIN Concept and its Types
JOINS in Action – Basic Example
Quick DOs and DONTs for Merge Queries
Merging Queries with more than 1 KeyID Column
Fuzzy Lookup
Data Preparation - Part 2
Using First Rows as Header
Cleaning Up Data with Case Change, TRIM, CLEAN
Working with Data Types
Removing Duplicates and Blank Rows, Split Column
Rectify Date Format using Data Type (Locale)
Adding a Conditional Column
Merge Columns (Concatenate)
Data Preparation (Re-Structuring) - Part 3
Unpivot Column
Group By
Transpose
