PDF
Efficient Data Analysis and Dynamic Reports Without Programming
In this two‑day workshop, participants learn how to efficiently analyze large datasets in Excel — without any programming. Using Power Query, multiple files from folders, tables from workbooks, or CSV files are automatically combined, cleaned, and prepared for PivotTables or dynamic evaluations.
Participants will learn hands‑on how to avoid using VLOOKUP, create data relationships between tables, and design meaningful reports. The seminar provides tips, tricks, and best practices for analyzing Excel data quickly, clearly, and dynamically.
Ideal for anyone who wants to efficiently manage large datasets, create automated analyses, and build professional reporting solutions.
Your Benefits at a Glance
- Automatically combine multiple files or tables
- Create dynamic PivotTables from CSV or Excel data
- Transform, analyze, and visualize data efficiently
- Tips and tricks for professional reporting
- Attend in person or online
Seminar Contents
Power Query Fundamentals
- Efficient introduction to Power Query
- Creating queries for imports
- Working with and managing queries
Importing Data
- Correctly formatting text files during import
- Importing multiple tables from one Excel workbook in a single step
- Importing data from the web
- Automatically importing multiple files from a folder
Editing Imported Data
- Applying data types correctly
- Editing and transforming rows and columns
- Pivoting and unpivoting columns
Analyzing and Visualizing Data
- Creating dynamic PivotTables and presenting data
- Highlighting top values using conditional formatting
- Creating subtotals and copying results
- Analyzing large datasets with PivotTables
- Using Power Pivot to create analyses across multiple tables
- Visualizing complex data with dynamic charts
Prerequisites
- Solid basic knowledge of Excel, regardless of the version
Target Audience
- Anyone who wants to efficiently handle large datasets
- Users who do not program but want to automate data analysis
- Anyone looking to create professional and dynamic Excel reports
