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)
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!