Excel Power Query Training for Beginners
- Total time
- Location
- At location, Online
- Starting date and place
Excel Power Query Training for Beginners
Provider rating:
Starting dates and places
placeKöln 27 Feb 2026 |
computer Online: Zoom 27 Feb 2026 |
placeKöln 29 May 2026 |
computer Online: Zoom 29 May 2026 |
placeKöln 28 Aug 2026 |
computer Online: Zoom 28 Aug 2026 |
placeKöln 13 Nov 2026 |
computer Online: Zoom 13 Nov 2026 |
Description
Schulungen der Extraklasse ✔ Durchführungsgarantie ✔ Trainer aus der Praxis ✔ Kostenfreies Storno ✔ 3=2 Kostenfreie Teilnahme für den Dritten ✔ Persönliche Lernumgebung ✔ Kleine Lerngruppen
Seminarziel
After this training, you will be able to import, link and prepare Power Query data in Excel. With the Power Query function language queries, you'll be able to create dynamic data summaries and visualisations.Inhalt
- Overview of Power Query operation
- Query Editor overview
- Importing data from various sources
- Preparing and adjusting field data types
- Combining data (merging and appending)
- Linking data tables (creating relationships)
- Complex queries, processing, and filtering the data source
- Data cleaning
- Grouping data
- Editing individual query steps
- Creating custom columns for own calculations
- Exemplary use of Power Query function language
- Dynamic evaluations of Power Query queries
- C…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Schulungen der Extraklasse ✔ Durchführungsgarantie ✔ Trainer aus der Praxis ✔ Kostenfreies Storno ✔ 3=2 Kostenfreie Teilnahme für den Dritten ✔ Persönliche Lernumgebung ✔ Kleine Lerngruppen
Seminarziel
After this training, you will be able to import, link and prepare Power Query data in Excel. With the Power Query function language queries, you'll be able to create dynamic data summaries and visualisations.Inhalt
- Overview of Power Query operation
- Query Editor overview
- Importing data from various sources
- Preparing and adjusting field data types
- Combining data (merging and appending)
- Linking data tables (creating relationships)
- Complex queries, processing, and filtering the data source
- Data cleaning
- Grouping data
- Editing individual query steps
- Creating custom columns for own calculations
- Exemplary use of Power Query function language
- Dynamic evaluations of Power Query queries
- Consolidating files and folders in Power Query queries
- Displaying evaluations with Excel PowerPivot
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.