Discover all the Possibilities offered by Excel Built-In Functions
This training will take you further in your knowledge of complex and nested functions. You will learn calculation functions for basic statistics, but also more complex functions. Equally important, you'll also learn how to find a specific value from another table and save valuable time.
6 hours
Advanced
7 participants
English - French
- Excel
- Compagny training
- Excel
- Layout
- Online training
- Private group training
- Public training
- Spreadsheets
- Templates
What you will learn
Goals
-With this training, you will be able to:
- Calculate statistics (IF, AND, OR, SUMIF, AVERAGEIFS…)
- Create and modify complex and nested functions
- Merge values from multiple cells into one
- Search for a value in another table according to a criterion (VLOOKUP, XLOOKUP, etc.)
Target audience
+Prerequisites
+Included with your course
+Content
+If you have any questions about registration, cancellations, training courses, etc., you can find answers in our FAQ.
Otherwise, you can always contact us.
Our clients testify
What could be better than the opinion of our participants who have experienced our courses.
-
“J'ai vraiment apprécié la facilité du formateur de rendre facile à comprendre la matière, mais aussi les trucs/raccourcis que je ne connaissais pas, ou la notion d'insérer des formules dans des formules, etc.
See more testimonials
Participant anonyme au cours EXE-301
Want to learn more about Excel ?
Sign up for our newsletter.Every month we share with you a tip about your favourite software..
