Course
Useful and efficient functions in Microsoft Excel («ME8»)
In this two-day Microsoft Excel course, you will learn how to use special and complex Excel functions, catch errors, and optimize your workbooks.
Duration
2 days
Price
1'290.–
Course documents
Digital courseware
Course facts
- Knowing a large number of useful functions that can be used in everyday life to increase productivity
- Simplifying tedious calculations with simple means, especially with nested functions
- Understanding the different types of function categories, how to search for functions, and how to detect and fix errors
- Introduction and Repetition
- Cell references
- Structure of functions
- Autocompletion of functions
- Using Names
- Create, edit, delete names
- Create names for ranges
- Special Text Functions
- EXACT
- CLEAN and TRIM
- NUMBERVALUE
- Statistical Functions
- FREQUENCY
- RANK.EQ
- RANK.AVG
- Matrix Functions
- OFFSET
- MATCH
- INDEX
- INDIRECT
- Date and Time Functions
- TODAY
- WEEKNUM
- DAYS
- DATEDIF
- Calculation of holidays
- Creating a dynamic calendar
- Mathematical Functions
- CEILING and FLOOR
- ISEVEN and ISODD
- ISTEXT and ISNUMBER
- INFO
- ERROR.TYPE
- 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:
This course is suitable for users of Excel 2019, 2016 and 2013.