Excel Module 1
Start with Excel
Beginner level – 1/2 day
The aim of this training is to feel comfortable with:
- Creating an Excel file
- Handling the sheet to make it more user-friendly
- Introduction to calculations/ formulas/functions
Excel Module 2
Create formulas
Beginner level – 1/2 day
The aim of this training is to feel comfortable with:
- Introduction to cell formulas and references
- Use of common functions
Excel Module 3
Manage lists
Intermediate level – 1/2 day
The aim of this training is to feel comfortable with:
- Operations on lists: sort, filter, group, display totals
- Preparing a sheet: mask lines/columns, freeze shutters, protect cells, print
- Use of common functions
Excel Module 4
Use conditional and search functions
Intermediate level – 1/2 day
The aim of this training is to feel comfortable with:
- Creation of nested formulae using constants and variables
- The logical aspects of type if... then... otherwise, ... applied to formatting and formulas
- Search Functions
Excel Module 5
Manage tables
Intermediate level – 1/2 day
The aim of this training is to feel comfortable with:
- The creation, management and use of tables;
- Functions of sorting / filter / input / formula / style / printing
Excel Module 6
Manage dynamic cross tables
Experienced level – 1/2 day
The aim of this training is to feel comfortable with:
- Dynamic cross tables queries
- Creating, managing and displaying dynamic cross tables
- Functions of sorting / filter / style / printing
Excel Module 7
Use the most common and advanced functions
Intermediate level – 1/2 day
The aim of this training is to feel comfortable with:
- Common functions of logics, statistics, dates, texts, research
Excel Module 8
Simulate with functions and formulas
Experienced level – 1/2 day
The aim of this training is to feel comfortable with:
- Formula simulation tools and optimization taking into account constraints
- Conditional formatting based on a formula
Excel Module 9
Use Power Query
Experienced level – 1/2 day
The aim of this training is to feel comfortable with:
- ETL approach: Extract, Transform, Load
- Connection to data sources
- Data transformation
