Objectives of the training
Be able to use Excel functions and formulas.Targeted audience
Any audience.Prerequisite
Have completed our Excel: essential functions training course or have knowledge of Excel's basic functions.Course architecture
- References
- Links
- Tables
- Named ranges
- Definition
- Operators
- Using formulas in tables and named ranges
- Definition
- Finding the right function for your needs
- Writing a function
- Using functions in arrays and named ranges
- Locating, investigating and debugging functions
- Logical functions
- Text functions
- Date functions
- Statistical functions
- Rounding functions
- Search functions
- Use of functions in conditional formatting
- Matrix functions and propagated tables (Microsoft 365)
- Reference functions
- Handling errors in functions
- Managing external data.
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quotePrivate or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote