UEL-5

Professional data analysis in Excel

Form of participation
Form of training
Length of training
  • 1 day (1×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Description

The aim of the programme is to introduce Excel data analysis tools specifically for people working in finance, business analysis, management and controlling. The focus of the training is on business analysis, analytical models, introducing Excel financial functions, univariate and multivariate financial models and the Excel tools used to analyse these models such as Case Study, Target Value Search, Solver and Data Table.

Outline

  • Financial functions, problems
  • Business activities and models
  • Univariate and multivariate financial models (cash flow)
  • Sensitivity analysis
  • Model construction: independent variables, constants, incorporation of business logic, user interface
  • Model analysis: Scenario manager, Goal seek, Solver, Data table
Outline (PDF)

Prerequisites

Advanced knowledge and experience of Excel is required to successfully complete the training.