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.

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
Klein
Instructor
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.
Free Courses
Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.
Premium Courses
Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.
Ready to get started?
Get in touch, or create an account