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.
Objectives
Be able to use Excel functions and formulas.
Is it for you ?
Any audience.
Prerequisite
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.
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
Details + / -
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.
💡 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 .
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote