Power Query

Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed molestie, velit ut eleifend sollicitudin, neque orci tempor nulla, id sagittis nisi ante nec arcu.

Category: Microsoft Excel

Course description

Level:	Advanced
Duration:	1 day

Power Query or ‘Get and Transform

Introduction

What is Power Query
Interface

Data Sources

From Web
From Excel File
From Current Workbook
From CSV or Text File
From Folder

Multiple Sources

Multiple Excel Tables or Named Ranges
Appending Queries
Merging Queries

Transforming and cleaning data

Editing Queries
Data Types
Columns – Move, Remove, Rename & Duplicate

Splitting Columns and Extracting Text
Merging Columns
Filtering Rows
Remove Duplicates & Errors
Sorting

Replace & Fill
Transforming Text & Numbers
Transforming Dates
Adding Custom & Index Columns
Adding Custom Calculated Columns

Adding Custom Date & Time Columns
Grouping
Unpivot
Transpose
Duplicating & Referencing Another Query
Add Column From Examples
Reuse and Share Queries

Data Destination

Loading to the Workbook Options
Loading to the Data Model or Power Pivot
Load Settings & Automatic Refresh

M Language

Introduction to M

Where to Edit and Write M
Using a Function to add a Custom Column
Reading M
Writing M
Type System
Splitting Text
Conditional Columns

Parameter Tables & Functions

Parameter Tables for Filtering

Dynamic Folder Paths
Dynamic File Paths
Manage Parameters
Variables

Duis egestas aliquet maecenas erat eros, fringilla et leo eget, viverpretium. Quisque sed augue tincidunt, posuere dui tempor, dapibus nisi. Donec vel lectus sapien. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.

Full Profile