Excel for Controllers
2-Day Workshop
Would you like to navigate through your Excel datasets efficiently, analyze them precisely, and visualize them professionally? In this seminar, you will learn the specific tools and functionalities that Microsoft Excel offers, particularly for controlling.
Discover how to make your work much easier with the right tools and functions. You will learn how to optimally use PivotTables, maneuver confidently through large datasets, and visualize them effectively. With just a few clicks, create insightful charts and learn how to record macros.
Through practical exercises, you will deepen your newly acquired knowledge and gain valuable tips and tricks for using Excel professionally.
Workshop Content
Dynamic Tables
- Advantages
- Editing & calculation
Formulas & Functions
- Data analysis, evaluation, & reporting
- Variance analysis (actual vs. planned)
Data Import with Power Query
- Importing data from various sources
- Avoiding import errors
- Correcting faulty data imports using text functions
- Other features in Power Query
Date, Time, & Text Functions
- Further functions
- Filtering
- VLOOKUP and XLOOKUP
- Simple & nested IF functions
- IF with AND/OR
- SUMIFS/AVERAGEIFS & other conditional functions
- Vertical and horizontal stacking
PivotTables
- Creating and designing
- Calculations within PivotTables
- Conditional formatting
- Slicers & timelines
- Visualization with charts
Macros
- Recording, adjusting, and applying
- Practical examples
Who Should Attend This Workshop?
This workshop is ideal for anyone who wants to use Excel efficiently and purposefully in controlling, especially when it comes to professionally preparing, analyzing, presenting, and automating data.