Professional Reporting with Excel & Power Query
2-Day Workshop
Learn how to combine multiple files in a folder without programming and then analyze the data further in Excel.
Discover how to create a Pivot Table from a CSV file, where the analysis remains dynamic. With just a few clicks, changes and additions to the source file are automatically incorporated.
Learn how to avoid using VLOOKUP() by importing multiple Excel sheets from a workbook and linking them together.
Our seminar offers you practical tips and techniques to make your data analysis more efficient and create meaningful reports.
WorkshopContent
Basics of Power Query
- Efficient introduction to Power Query
- Creating queries to import data
- Working with queries
Importing Data
- Correcting text files during import
- Importing multiple tables from a single Excel workbook in one step
- Importing data from the web
- Importing multiple files from a folder in one step
Editing Imported Data
- Applying data types
- Editing cells and columns
- Transforming data
- Unpivoting columns
- Pivoting columns
Data Analysis
- Creating dynamic tables and presenting data
- Highlighting top values with conditional formatting
- Creating intermediate results and copying results
- Analyzing large datasets with Pivot Tables
- Performing analyses across multiple tables with Power Pivot
- Visualizing complex data with dynamic charts
Who Should Attend This Workshop?
This workshop is ideal for anyone who wants to easily handle large datasets without needing to program in Excel and wishes to make their work in Excel more efficient overall.