Using advanced Excel functions to facilitate decision-making.
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 functions.
Is it for you ?
Any audience.
Prerequisites
Have completed our Excel: essential functions training course or have knowledge of Excel's basic functions. This training is not suitable for users with Mac computers.
What You'll Walk Away With
- ✓ Structure and ensure data accuracy using references, links, tables, and named ranges
- ✓ Build robust formulas using operators and best practices
- ✓ Select and apply the right functions (logical, text, date, statistical, lookup)
- ✓ Debug formulas and manage errors to secure calculations and analysis
- ✓ Use advanced functions (arrays, dynamic arrays, conditional formatting, external data)
Training 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.
1 Reminders and best practices on data management
- References
- Links
- Tables
- Named ranges
2 Using formulas efficiently
- Definition
- Operators
- Using formulas in tables and named ranges
3 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
4 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.
📌 Practical information
Our training sessions are offered in Montreal or Quebec City, in person or in a virtual classroom. Dates and locations are specified when you select your session below. If you have any questions, check out our FAQ.
