Excel 2019: From essential to advanced skills (with self-assessment test) (S-EL0001)

No prior knowledge of Excel is necessary. However, some use of the software may make it possible to progress faster.

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 testand 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)

• 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)