The beauty and strength of Excel lies in the functions available. This Excel training course will help you take better advantage of the data you have, by processing it intelligently with the right function(s).
Objectives
To provide the knowledge and skills required to make effective use of the many functions available with Microsoft Excel.
Is it for you ?
Any audience.
Prerequisite
Basic knowledge of Excel.
Your benefits
Content
MS Excel is a powerful spreadsheet program, thanks to its many functions and formulas. They allow you to process data according to your needs and thus to draw lessons that will help you make decisions or simply to understand.
Reminders and best practices on data management
- References
- Links
- Tables
- Named ranges
Using formulas efficiently
- Definition
- Operators
- Using formulas in tables and named ranges
Using functions efficiently
- Definition
- Finding the right function for your needs
- Writing a function
- Using functions in arrays and named ranges
- Locating, investigating and debugging functions
Practical cases of using 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.
Notes
Note: Most of the functions presented are available in all Excel versions (2016, 2013, 2010, 2007 and 2003).
💡 Useful information
Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .
