FR
EN
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
Use range names
Statistical functions
- MAX, MIN, AVERAGE, COUNT, COUNTIF(S), COUNTA…
Text functions
- TEXT, RIGHT, LEFT, MID, CONCATENATE, UPPER, LOWER, PROPER, SUBSTITUTE, TRIM …
Logical functions
- IF, AND, OR, IFERROR…
Lookup functions
- VLOOKUP, INDEX, MATCH…
Date functions
- TODAY, DATE, YEAR, MONTH, DAY, DATEDIF, EDATE, WEEKDAY, NETWORKDAYS …
Math functions
- ROUND, ROUNDUP, ROUNDDOWN, SUMIF(S)….
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!