Excel for Controllers
- Total time
- Location
- At location, Online
- Starting date and place
Excel for Controllers
Provider rating:
Starting dates and places
placeKöln 28 May 2026 until 29 May 2026 |
computer Online: Zoom 28 May 2026 until 29 May 2026 |
placeKöln 13 Aug 2026 until 14 Aug 2026 |
computer Online: Zoom 13 Aug 2026 until 14 Aug 2026 |
placeKöln 5 Nov 2026 until 6 Nov 2026 |
computer Online: Zoom 5 Nov 2026 until 6 Nov 2026 |
Description
Schulungen der Extraklasse ✔ Durchführungsgarantie ✔ Trainer aus der Praxis ✔ Kostenfreies Storno ✔ 3=2 Kostenfreie Teilnahme für den Dritten ✔ Persönliche Lernumgebung ✔ Kleine Lerngruppen
Seminarziel
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.Inhalt
-
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 wi…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Schulungen der Extraklasse ✔ Durchführungsgarantie ✔ Trainer aus der Praxis ✔ Kostenfreies Storno ✔ 3=2 Kostenfreie Teilnahme für den Dritten ✔ Persönliche Lernumgebung ✔ Kleine Lerngruppen
Seminarziel
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.Inhalt
- 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
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.