FR
EN
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…
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!
