Microsoft Excel Power Query Course (PQEX)

Fast Lane Benelux B.V.

Microsoft Excel Power Query Course (PQEX)

Level

Higher professional education (hbo)

Kind

Training

Subject

Automation and IT

More information and registration at Fast Lane Benelux B.V.

Description

Introduction and Objectives Introduction to Power Query - What is Power Query? - Overview of the Power Query Editor (Interface) - The four phases (Connect, Transform, Combine and Load) - Basic concepts - What are Applied steps? Connecting to data sources - Importing data (e.g., CSV/Text, Excel) - Power Query interface - Refreshing query - ‍ Load and use Data Query - Load the data into Excel worksheet - Creating a Connection only - Create a Pivot Table - Refreshing the query ‍ Transforming and combining the data - Combining data tables (Merge and Append) - Column operations (e.g., Rename, Move, Delete, Duplicate) - Row operations (e.g., Deleting blank and unnecessary rows) - Filtering, sorting, splitting, replacing values, changing data types, remove blank rows, changing case - Remove and replace first row - Transposing and Unpivoting Data - Add a calculated column - Using the group by (Basic/Advanced) - Fill up/down feature (show PQE Script)