FR
EN
LU
DE
Details
Goals
Format a list as a table, use standard and advanced filters, sort a list, use database functions
Prerequisite
Basic Excel knowledge
Contents
Introduction & Format as Table
- Definition and rules to follow when building a list
- Freeze panes
- Remove duplicates
- Format a list as table
- Name a table
- Add a totals row to a table
- Calculated columns & structured references
Sorts and Filters
- Sort by values
- Sort by multiple criteria
- Sort by colors
- Autofilter
- Filter by values
- Filter by color
- Advanced Filters
- Extract data
Database functions
- Build criteria ranges
- Use database functions in formulas: DSUM, DAVERAGE, DMAX, DMIN…
Sign up
Next session(s)
This training is exclusively on request. Contact us to get a personalized offer.
Sessions available in
- FR
- DE
- EN
- LU
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
0.50 Jour
€ VAT excl. / participant