Excel 2013

Standard tables (simple and printed on one page) and slightly more complex tables

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 worksheets and files Large tables : page setup and print options
Data formats (custom - conditional ...)
Formulas and functions (absolute references - names)
Navigate - Reorganize - Compare
Charts (simple intro)
Sort and Filter (simple intro)
Workbook and cell protection (simple)

Français

Mixte

English

Charts and graphic tools

Content (in brief)

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

Français

Mixte

English

Data Tables (Lists)

Content (in brief)

Convert into a list
Managing duplicates
The TRIM and CONCATENATE functions
Data validation
Tips to select and navigate in a very large worksheet
Defining a data table (old : list)
Sorting
Filtering : simple and advanced
Subtotals - integrated inside the table
Pivot tables
BD functions

Français

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 Analysis tools : custom views - scenarios - simple & double entry table - Goal seek

Français

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

Français

Mixte

English

© Copyright : Office Doc / Web development by Office Doc