This training is offered in the form of distance learning. More information
In collaboration with:
Description
Objectives
- Format a list as a table, use standard and advanced filters, sort a list, use database functions
Programme
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…
Prerequisites
- Basic Excel knowledge
Conditions
Course Material
The training material will be handed out at the beginning of the course.
Location
Classe virtuelle
Calculate the itinerary
A distance