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:

FunctionExample 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

What our clients say

"We use data2impact as provider of Excel training for our internal consultants and Finance Graduates in Novo Nordisk. We continue to use them due to a very high quality in the training and their ability to customize their services to fit our needs. I would highly recommend working with data2impact!"

Nikolaj Kromann Jørgensen
Director and EA to SVP Corporate Finance Management Support
Novo Nordisk