S-EL0001 - Excel 2019: From essential to advanced skills (with self-assessment test)
Public cible
Any user who wishes to discover or deepen their knowledge of Excel’s features.
Objectives
Discover Excel 2019 and Office 365 versions, master data entry and formula,
determine the format and layout of your tables and charts. You will learn how to
manage long tables by filtering and sorting and you will be able to synthetize
data using pivot tables.
Assessment test and training - Depending on
the learner's level, the training will be assigned automatically.
If the
final test result is less than 60%:
The essential modules:
Level 1:
Essential skills
Level 2: Intermediate skills
Complementary
material:
Level 3: Advanced skills
If the final test result is above
than 60%:
The essential modules:
Level 2: Intermediate skills
Level
3: Advanced skills
Complementary material:
Level 1: Essential skills
For both training paths (regardless of result)
The essential modules:
Office 2019: Use cases
Excel 2019: Use cases
Complementary
material:
Excel 2019 and Office 365 versions Reference book (digital course
material)
Content
- Level 1: Essential skills:
- get started in Excel;
- set out your first Excel calculations;
- look good with easy formatting;
- print an attractive document;
- increase your efficiency;
- multiple worksheets and various views.
- Level 2: Intermediate skills:
- move on to more complex tables;
- let charts explain your data;
- create striking charts;
- illustrate your data;
- database functionality with an Excel table;
- see your data from a different angle: pivot tables and charts.
- Level 3: Advanced skills:
- grasped the basics?
- take the next step;
- find the right function for your calculation;
- discover unexpected features;
- share and collaborate effectively.
- Office 2019: Use cases.
- Excel 2019: Use cases:
- implementing quality control;
- analysing a library's attendance levels;
- monitoring the budget;
- minimising costs.
- Excel 2019 and Office 365 versions Reference book (digital course
material)
Prerequisites
No prior knowledge of Excel is necessary. However, some use of the software may make it possible to progress faster.