Excel Power Query Training for Beginners - Seminar / Kurs von GFU Cyrus AG
Inhalte
- 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
- 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 ...
Lernziele
After this training, you will be able to import, link and prepare Power Query data in Excel. With the Power Query function language queries, youll be able to create dynamic data summaries and visualisations.
After this training, you will be able to import, link and prepare Power Query data in Excel. With the Power Query function language queries, youll be able to create dynamic data summaries and visualis ... Mehr Informationen >>
Zielgruppen
Business analysts, controllers from finance and marketing, and all Microsoft Excel users who need comprehensive data analysis and a good basic knowledge of Excel and a fundamental understanding of data structures.
Business analysts, controllers from finance and marketing, and all Microsoft Excel users who need comprehensive data analysis and a good basic knowledge of Excel and a fundamental understanding of dat ... Mehr Informationen >>
Termine und Orte
| Datum | Dauer | Preis | ||
|---|---|---|---|---|
| Köln, DE | ||||
| 23.02.2024 | 7 h | Mehr Informationen > | Jetzt buchen › | |
| 17.05.2024 | 7 h | Mehr Informationen > | Jetzt buchen › | |
| 23.08.2024 | 7 h | Mehr Informationen > | Jetzt buchen › | |