Power Query – Beginner Level Training
Level
BeginnerDuration
8h / 1 dayDate
Individually arrangedPrice
Individually arrangedPower Query – Beginner Level Training
The Power Query – Beginner Level training is an intensive course designed for those seeking solid foundations in using Power Query to efficiently manage and process data in Excel.
What You Will Learn
- By the end of this training, participants will gain solid foundations in using Power Query for importing, managing, and transforming data in Excel, enabling them to analyze and present spreadsheet data more effectively.
Who is this training for?
The target group includes people who want to learn about Power Query’s capabilities and automate processes of importing, managing, and transforming data in spreadsheets. No prior programming experience or advanced Excel knowledge is required.
Training Program
-
Importing Data from Various Sources
- Databases
- Text files
- Folder import
- Web pages
- Excel workbooks
-
Managing Queries
- Refreshing queries
- Different ways of loading data from queries
- Appending queries
- Merging queries
- Working with multiple queries
-
Data Transformation and Cleaning in Power Query Editor
- Working with columns
- Working with rows
- Defining and changing data types
- Unpivoting columns
- Pivoting columns
- Grouping and summarizing data
- Text, numeric, and date transformations
