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
- Use functions: SumIf, CountIf, Vlookup, If, And, Or, Match ….
- Nested functions
Data Table
- Create a data table (Insert Table)
- Create formulas using references of a Data table
Managing Lists
- Filter data: advanced filters
- Remove duplicates
- Use automatic totals (Subtotals)
- Recommended Pivot Tables
- Cross data into a table (PivotTable) or a graph (PivotChart)
Check data
- Auditing tools
- Achieve a target value (Goal seek)
- Evaluate a formula
Sign up
Next session(s)
Thu.
07
Aug.
Fri.
08
Aug.
2025
Tarif de 540€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Thu.
21
Aug.
Fri.
22
Aug.
2025
Price will be €540 according to indexation on 05/01/2025 (effective as from July 1st)
Thu.
11
Sep.
Fri.
12
Sep.
2025
Tarif de 540€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Mon.
10
Nov.
Tue.
11
Nov.
2025
Tarif de 540€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Thu.
13
Nov.
Fri.
14
Nov.
2025
Price will be €540 according to indexation on 05/01/2025 (effective as from July 1st)
Mon.
08
Dec.
Tue.
09
Dec.
2025
Preis beträgt 540 € nach Indexierung am 01.05.2025 (gültig ab 1. Juli)
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!
