Course
Microsoft Excel for Controllers («EBX»)
In this seminar, you will learn how to optimally use Excel for your controlling tasks. A large selection of relevant Excel functions, methods and options will be developed for your financial management practice.
Duration
2 days
Price
2'200.–
Course documents
Digicomp course documentation
Course facts
- Mastering selected functions relevant to your own controlling practice with confidence
- Creating meaningful graphics to visualise large amounts of data
- Using Excel productively for decision-making thanks to practice-oriented course content
- Getting support after the course with helpful practical tips and comprehensible application examples thanks to specially developed Digicomp course materials
1 Introduction with various tips & tricks for increasing efficiency and repetition of basic functions
2 The most important Excel functions for Controlling
- Logic functions (IF, AND, OR, IF ERROR, etc.)
- Matrix functions (REFERENCE, INDEX, RANGE.SHIFT, etc.)
- Statistics functions (MAX, MIN, COUNT/SUM IF(S), etc.)
- Financial mathematics functions ((V)ROUND, RMZ, TREND, etc.)
- Text functions (LEFT, RIGHT, PART, FIND, etc.)
- Date functions (TODAY, DATEDIF, etc.)
3 Summaries, analyses, and visualizations of data with:
- professional pivot tables
- conditional formatting
- sparklines
- diagrams (incl. special cases)
4 Exchange and protect data
Bring a USB stick with you to the course so you can save your exercises from the course and take them home with you.
This course is aimed at experts and managers from the fields of controlling, finance and accounting, and general managers with responsibilities in controlling and business administration.
Basic knowledge of Excel according to the following courses:
No Visual Basic programming is performed.