Excel for Advanced Users
Organisationsentwicklung
Mittwoch, 1. Juli 2026, von 9-17 Uhr, online. Kosten: 216 Euro. Ein Angebot vom Haus des Stiftens.
Advanced course
In this practical advanced course, you will deepen your knowledge of Excel and learn how to use complex formulas, analyses and charts efficiently. You will create your own templates, automate calculations and visualise data professionally. You’ll also learn how to use pivot tables, link workbooks and manage data securely – ensuring optimal organisation in your day-to-day work.
Contents of this online workshop
Formulas & calculations
- Structure and composition of complex formulas (e.g. IF, VLOOKUP, date functions)
- Calculations using structured tables & references
- Using forecasts, filters and conditional formatting effectively
Data management & security
- Data validation, validation rules & drop-down lists
- Making effective use of protection functions & range locks
- Links across multiple workbooks
Visualisation & Analysis
- Creating, designing & saving charts as templates
- Reusing results in Word & PowerPoint
- Introduction to pivot tables for efficient data analysis
Tips & best practices
- Optimising large data sets
- Efficient organisation using your own templates
- Useful shortcuts & tricks for everyday work