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)
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!