FR
EN
Details
Goals
Being able to use the advanced spreadsheet functionalities.
Prerequisite
Basic Excel skills.
Contents
Functions (refresh)
-
Insert Function using the wizard
-
Insert function manually, semi-automatic formula input
Use range names (refresh)
-
Create and use a range name
-
Edit and delete a range name, define its scope (file, spreadsheet)
Conditional formatting
-
Apply a predefined conditional formatting
-
Customize a conditional formatting
Advanced Functions
-
COUNTIFS, SUMIFS
-
XLOOKUP
-
IF, IFS, SWITCH
-
IFERROR/IFNA
-
Date Functions
-
Text Functions (Concat, text join)
-
Dynamic arrays
Data Table
-
Create a data table (Format as Table)
-
Create formulas using structured references in a Data table
Managing Lists
-
Remove duplicates
-
Recommended Pivot Tables
-
Cross data into a table (PivotTable) or a graph (PivotChart)
-
Create a PivotTable based on multiple source tables (Data Model)
-
Forecast sheet
Check data
-
Auditing tools
-
Achieve a target value (Goal seek)
-
Evaluate a formula
-
Data Types
Sign up
Next session(s)
Tue.
01
Jul.
Wed.
02
Jul.
2025
Price will be €540 according to indexation on 05/01/2025 (effective as from July 1st)
Thu.
03
Jul.
Fri.
04
Jul.
2025
Preis beträgt 540 € nach Indexierung am 01.05.2025 (gültig ab 1. Juli)
Mon.
21
Jul.
Tue.
22
Jul.
2025
Tarif de 540€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Thu.
24
Jul.
Fri.
25
Jul.
2025
Preis beträgt 540 € nach Indexierung am 01.05.2025 (gültig ab 1. Juli)
Thu.
21
Aug.
Fri.
22
Aug.
2025
Preis beträgt 540 € nach Indexierung am 01.05.2025 (gültig ab 1. Juli)
Mon.
25
Aug.
Tue.
26
Aug.
2025
Tarif de 540€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Thu.
28
Aug.
Fri.
29
Aug.
2025
Price will be €540 according to indexation on 05/01/2025 (effective as from July 1st)
Mon.
15
Sep.
Tue.
16
Sep.
2025
Tarif de 540€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Thu.
23
Oct.
Fri.
24
Oct.
2025
Tarif de 540€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Thu.
30
Oct.
Fri.
31
Oct.
2025
Price will be €540 according to indexation on 05/01/2025 (effective as from July 1st)
Wed.
12
Nov.
Thu.
13
Nov.
2025
Preis beträgt 540 € nach Indexierung am 01.05.2025 (gültig ab 1. Juli)
Thu.
20
Nov.
Fri.
21
Nov.
2025
Tarif de 540€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Wed.
10
Dec.
Thu.
11
Dec.
2025
Price will be €540 according to indexation on 05/01/2025 (effective as from July 1st)
Mon.
15
Dec.
Tue.
16
Dec.
2025
Tarif de 540€ 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!