top of page
Information Générale.
Advanced Excel Formulas
Practically: Making Excel work for you, stop doing all the hard work and let this software handle some by creating automatic IF statements and Quick Table to Table references.
Outcomes: You will learn 2 key functions of Excel – IF and VLOOKUP. You will get to know their strengths and weaknesses as well as alternatives to both when they don’t fit your needs. These 2 functions help save a lot of time and make your life in Excel more automatic. After this class you will work a lot less and Excel will work a lot more for you!
Jonathan Denis
Raisons de communiquer
1. Questions et demandes
2. Documents et exercices
Votre formateur
LVL 3 - Condensed Advanced Excel
Horaire de formation.
08:30 to 09:00 - Bienvenue au Zoom (Optionnel)
09:00 to 10:00 -
10:00 to 11:00 - Pause & Exercice
11:00 to 12:00 -
12:00 to 13:00 - Le Lunch
13:00 to 14:00 -
14:00 to 15:00 - Pause & Exercice
15:00 to 15:30 - Conclusion
15:30 to 16:00 - Questions & Évaluation
Other useful functions
LOOKUP FUNCTIONS
LOGICAL FUNCTIONS
LOGICAL FUNCTIONS
15 minutes avant - Bienvenue au Zoom (Optionnel)
Premières 45 minutes -
Dernières 15 minutes - Questions
DATES à VENIR
No Dates
Available
JOUR 1
08:30 to 09:00 - Bienvenue au zoom (Optionnel)
09:00 to 10:00 -
10:00 to 11:00 - Pause et exercice 1
11:00 to 12:00 -
12:00 to 13:00 - Le lunch
13:00 to 14:00 -
14:00 to 15:00 - Pause et exercices 2 & 3
15:00 to 15:30 - Conclusion
15:30 to 16:00 - Question & évaluation
Other useful functions
LOOKUP FUNCTIONS
LOGICAL FUNCTIONS
JOUR 2
08:30 to 09:00 - Bienvenue au zoom (Optionnel)
09:00 to 10:00 -
10:00 to 11:00 - Pause et exercice 4
11:00 to 12:00 -
12:00 to 13:00 - Le Lunch
13:00 to 14:00 -
14:00 to 15:00 - Pause et exercice 5&6
15:00 to 15:30 - Conclusion
15:30 to 16:00 - Question & Évaluation
JOUR 1
08:30 to 09:00 - Bienvenue au zoom (Optionnel)
09:00 to 10:00 -
10:00 to 11:00 - Pause et exercice 1
11:00 to 12:00 -
12:00 to 13:00 - Le lunch
13:00 to 14:00 -
14:00 to 15:00 - Pause et exercices 2 & 3
15:00 to 15:30 - Conclusion
15:30 to 16:00 - Question & évaluation
LOOKUP FUNCTIONS
LOGICAL FUNCTIONS
JOUR 2
08:30 to 09:00 - Bienvenue au zoom (Optionnel)
09:00 to 10:00 -
10:00 to 11:00 - Pause et exercice 4
11:00 to 12:00 -
12:00 to 13:00 - Le Lunch
13:00 to 14:00 -
14:00 to 15:00 - Pause et exercice 5&6
15:00 to 15:30 - Conclusion
15:30 to 16:00 - Question & Évaluation
bottom of page