FR
EN
LU
DE
Details
Goals
Manage your spreadsheets in an efficient way.
Prerequisite
Basic Excel skills.
Contents
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 (version 2013 and later)
- 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
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