Excel for Controllers in Köln - Seminar / Kurs von GFU Cyrus AG
Inhalte
- Preparing and processing of data
- Importing data
- Database functions
- Filters
- Consolidating data
- Basic financial calculations
- Budget/actual comparisons
- Financial functions for cash flow analysis
- ABC analysis
- Margin analysis
- Goalseek
- Solver
- Scenario Manager
- Budget/actual comparisons
- Excel functions
- Complex formulas
- Date fields
- Reference function
- Graphical representation
- Graph structure
- Graph wizard
- Chart types
- Pivot tables
- Building a pivot table
- Creating pivot tables
- Working with pivot tables
- Preparing and processing of data
- Importing data
- Database functions
- Filters
- Consolidating data
- Basic financial calculations
- Budget/actual comparisons
- Financial functions for cash flow analysis
- ABC a ...
- Budget/actual comparisons
Lernziele
With the help of Excel, you will create professional financial controlling reports. The exercises form a good basis for complex controlling tasks, and individual issues can be addressed during the course.
Zielgruppen
This training is intended for controllers with knowledge of excel.