This training is offered in the form of distance learning. More information
In collaboration with:
Description
Objectives
- Manage your spreadsheets in an efficient way
Programme
- Manipulate large tables
- Definition
- Rules for building a list
- Freeze panes, repeat headers …
- Format as table
- Table name
- Add a totals row
- Moving & selecting in an efficient way
- Data validation
- Find/replace data
- Conditional Formatting
- Apply a conditional formatting to cells
- Create a rule
- Manage the formatting rules: edit, delete
- The flash fill
- Automatically extract or combine data
- Start flash fill automatically/manually
- Managing sheets
- Add, rename, delete a sheet
- Move & copy a sheet
- Set a color to the sheet tab
- Create and manage links
- Keyboard shortcuts
Prerequisites
- Basic Excel skills
Conditions
Course Material
The training material will be handed out at the beginning of the course.
Location
Classe virtuelle
Calculate the itinerary
A distance