Power Query Data Preparation Without Macros
1-Day Workshop
Save valuable time and utilize the Power Query add-in for importing external data. Learn how to pull together information from multiple files and clean data without writing a single line of code.
Let Power Query work for you and automate repetitive steps in importing and consolidating data from various sources. Our seminar will provide you with practical methods to optimize your workflows and save time by using Power Query effectively.
Workshop Content
Overview of Power Query
- The power of Power Query
- Installing and activating Power Query
- Power Query interface
Importing and Preparing Data
- Importing data from text files for analysis
- Viewing each import step
- Removing unnecessary columns
- Minimizing the amount of data before importing
- Assigning correct data types and formatting
Consolidating Data and Optimizing Queries
- Importing and processing files from a folder with a single query
- Merging data from multiple Excel worksheets
- Retrieving information from database systems
- Using public data from web-based sources
- Merging multiple Power Query queries
- Duplicating and customizing queries for specific audiences
Transforming Data
- Defining calculated columns
- Linking data without using VLOOKUP
- Unpivoting data (instead of pivoting)
Understanding the Core of Power Query
- The M formula language in the advanced editor
- Creating custom functions in M
- Using program parameters from Excel
Who Should Attend This Workshop?
This workshop is ideal for professionals in finance, management, and controlling, as well as data analysts and staff members in supporting functions, especially those who want to efficiently import, process, and analyze large datasets in Excel.