Excel 2007

Standard tables (simple and printed on one page)

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

French

Mixte

English

More complex tables

Content (in brief)

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

French

Mixte

English

Charts

Content (in brief)

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

French

Mixte

English

Data Tables (Lists)

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

French

Mixte

English

Consolidation, Outline and Analysis tools

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

French

Mixte

English

Functions and Protection

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

French

Mixte

English

Customize and Automate

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

French

Mixte

English

© Copyright : Office Doc / Web development by Office Doc