Content (in brief)

Description of the 2007 environment
Basic commands linked to navigating, selecting, typing ...
Structure of the table (row or column width/height - delete - insert)
Formats
Cut-copy-paste : excel specific implications
Formulas and easy functions
Page setup and print options
Managing files

Content (in brief)

Large tables : page setup and print options
Data formats (custom - conditional ...)
Formulas and functions (absolute references - names)
Navigate - Reorganize - Compare

Content (in brief)

Creating and choosing the chart type
DESIGN Tab
LAYOUT Tab
FORMAT Tab
Creating a chart template.
Samples of less common charts

Content (in brief)

Defining a data table (old : list)
Sorting
Duplicates
Filtering : simple and advanced
Subtotals - integrated inside the table
Pivot tables
Convert into a table or list
Data validation
Outline

Content (in brief)

Consolidation : 3D references or consolidating using the outline
Outline
Custom views
Scenarios
One-entry or double-entry tables
Goal seek and solver

Content (in brief)

Absolute and relative references
Functions : general principles
Names
Examples of functions : COUNT, COUNTBLANK, COUNTIF - SUMIF - AND, OR - VLOOKUP (H) - INDEX, MATCH, EXACT, SUBTOTAL and so on
Audit
Conditional formats
Protection

Content (in brief)

Customize
The types of templates
The other files linked to customization
Customizing the Quick Access Toolbar

Automate
Introduction to macro-instructions : create, modify ...
Macro settings (security)
Custom button for a macro
Forms
Special functions : converting to PDF or XPS format