FR
EN
LU
DE
Details
Goals
Be able to use advanced features in Excel.
Prerequisite
Basic Excel skills.
Contents
Use Range
- Create and use a range name
- Change and delete a range name, define its scope (workbook, worksheet)
Calculations with advanced functions
- Use functions: SumIf, CountIf, Vlookup, If, And, Or, Match ….
- Nesting functions
- Goal seek
Conditional Formatting
- Apply a built-in conditional format
- Customize a conditional format
Manage databases
- Sorting data: by value, by color or icon
- Filtering data: automatic and advanced filters
- Remove duplicates
- Use subtotals
- Pivot Tables
- Pivot Charts
Check data
- Use the Audit tools
- Evaluate a formula
Consolidate data
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!
You have added a training to your shopping card
- En
- Fr
- De
2.00 Jours
440€ VAT excl. / participant