Cette formation est proposée sous forme de formation à distance. En savoir plus
En collaboration avec:
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
Vous souhaitez rester à jour sur notre offre de formation ?
Inscrivez-vous à la newsletter