Details
Goals
Be able to create formulas including one or more functions.
Prerequisite
Basic knowledge of Excel.
Contents
Use the function wizard:
- Search,
- Categories,
- Arguments,
- Help
Use absolute references in formulas
Statistical functions
- MAX, MIN, AVERAGE, COUNT, COUNTIF(S), COUNTA…
Text functions
- MID, RIGHT, LEFT, CONCATENATE…
Logical
- IF
Date and Time
- TODAY, DATEDIF, DATE, YEAR, MONTH, DAY…
Sign up
Next session(s)
Fri.
01
Aug.
Formation online de 9h00 à 12h30 Tarif de 175€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Fri.
03
Oct.
Online cours from 9:00 am to 12:30 pm Price will be €175 according to indexation on 05/01/2025 (effective as from July 1st)
Wed.
10
Dec.
Formation online de 9h00 à 12h30 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!
You have added a training to your shopping card
0.50 Jour
170€ VAT excl. / participant