Microsoft Excel Power Query

1 Day Course
Power Query, now called Get and Transform, is a data transformation and data preparation engine that lives in Microsoft Excel. It will help you clean, transform, append and merge your data with ease.

Introduction

What is Power Query?
Pivot Tables or Power Query?

Import and Refresh

Import Data in Power Query
Refresh Data
Close and Load
Fix Broken Links to Data

Mange Queries

Duplicate Query
Reference Query
Query Dependencies
Delete and Rename Queries

Sort and Filter

Sort Data
Filter Data
Filter Conditions

Clean Up Data

Data Types
Data profiling
Fixing Nulls and Errors
Remove Duplicates
Find and Replace

Text Manipulations

Format Text
Concatenate and Column by Example
Split Column
Extract
Prefixes and Suffixes

Transform Data

Pivot in Power Query
Pivot without Aggregating
Append Data
Merge Data
Un-pivot Data

Power Query Functions

Date Functions
If Function