FR
EN
LU
DE
Details
Goals
Connect to data, transform it and display the results in Excel.
Prerequisite
Very good Excel knowledge
Contents
Connect to data
- Connect to Excel data,
- Connect to flat text files (csv, txt),
- Connect to a database.
Load Queries to the workbook
- Load a query to a worksheet,
- Create a connection without loading the data,
- Create a PivotTable based on a Power Query connection
Simple transformations
- Delete rows and / or columns
- Pivotting / unpivotting columns,
- Sorting and filtering,
- Split columns,
- Change a columns data type,
- Extract characters from a column.
Combine data
- Merge two tables based on a column,
- Append the contents of a table to another table
Advanced transformations
- Add a column from a sample of the expected result,
- Create a formula using the editor,
- How to use parameters,
- Create a custom function to be used in the Power Query editor.
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!