Microsoft Excel for Controllers («EBX»)

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:

COURSE
Efficient calculations and visualizations with Microsoft Excel («ME2»)
2 days
• Basel, Berne, Geneva, Lausanne, Virtual Training, Zürich
CHF
1'140.–
Learn more

No Visual Basic programming is performed.