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).
Duration
1 day
Schedule
See training dates for details
Regular fee
$375
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$340
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
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
If you have any questions about registration, cancellation, schedules, language of instruction, etc. you will find answers in our FAQ.
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 quoteDuration
1 day
Schedule
See training dates for details
Regular fee
$375
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$340
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 quote