Function-based training

Depending on the target group, the content of each training course may be custom-tailored to a specific function. This includes not only examples and exercises, but also – and more importantly – the techniques and tools in focus during the course.

As an example, please see below a list of potential topics for Intermediate Excel training:

Function	Example content
Controlling	KPI dashboard design Efficient and flexible sales data analysis
Finance	Complex financial model building Sensitivity analysis of key assumptions in an investment model Linking online sources (e.g. stock quotes, exchange rates)
Human Resources	Data combination across different data sources (e.g. matching employees between time registration and payment system) Workday and time calculations
Marketing	Customer segmentation Customer survey design, aggregation and result analysis Efficient and flexible sales data analysis
Pricing	Simulation models for pricing redesign Efficient and flexible sales, customer and pricing analysis
Procurement	RfQ design, consolidation and analysis Total cost of ownership (TCO) modelling Analysis of large purchasing data sets
Risk Management	Data aggregation across different data sources Risk mitigation: Errors in corporate spreadsheets - identification strategies and error prevention methods