Useful and efficient functions in Microsoft Excel («ME8»)

1 Introduction and Repetition

• Cell references
• Structure of functions
• Autocompletion of functions

2 Using Names

• Create, edit, delete names
• Create names for ranges

3 Special Text Functions

• EXACT
• CLEAN and TRIM
• NUMBERVALUE

4 Statistical Functions

• FREQUENCY
• RANK.EQ
• RANK.AVG

5 Matrix Functions

• OFFSET
• MATCH
• INDEX
• INDIRECT

6 Date and Time Functions

• TODAY
• WEEKNUM
• DAYS
• DATEDIF
• Calculation of holidays
• Creating a dynamic calendar

7 Mathematical Functions

• CEILING and FLOOR
• ISEVEN and ISODD
• ISTEXT and ISNUMBER
• INFO
• ERROR.TYPE

8 More Features and Tips

• CONVERT
• Error groups, error messages, formula monitoring
• Tips & Tricks

This course is aimed at users who already have advanced knowledge of formulas and functions in Excel and want to increase their efficiency in handling functions.

This course is not intended for beginners. Knowledge of Excel similar to the following course is required:

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

This course is suitable for users of Excel 2019, 2016 and 2013.