FR
EN
Details
Goals
Be able to create more advanced formulas
Prerequisite
Basic Excel functions
Contents
Use range names
Nested functions
Lookup functions
- VLOOKUP, INDEX, MATCH…
Logical functions
- IFERROR, AND, OR…
Text functions
- UPPER, LOWER, PROPER, SUBSTITUTE, TRIM…
Date and Time
- EDATE, WEEKDAY, NETWORKDAYS…
Math
- ROUND, ROUNDUP, ROUNDDOWN, SUMIF(S)….
Sign up
Next session(s)
Fri.
01
Aug.
Formation online de 13h30 à 17h00 Tarif de 175€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Fri.
03
Oct.
Online cours from 1:30 pm to 5:00 pm Price will be €175 according to indexation on 05/01/2025 (effective as from July 1st)
Wed.
10
Dec.
Formation online de 13h30 à 17h00 Tarif de 175€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
To go further
These courses
may be of interest to you
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!