S-EL0002 - Excel 2021: From essential to advanced skills (with self-assessment test)
Target Audience
Any user who wishes to discover or deepen their knowledge of Excel’s features.
Objectives
- Master the basics of Excel 2021: Enter and format data.
- Use simple and advanced calculation formulas: Optimize calculations and analyses.
- Create and customize charts: Visualize data effectively.
- Manage long tables: Organize and analyze large amounts of data.
- Use pivot tables: Summarize and explore data.
- Apply advanced tools: Automate tasks and improve productivity.
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.
Prerequisites
No prior knowledge of Excel is necessary. However, some use of the software may make it possible to progress faster.
Notes
Assessment test and training - Depending on the learner's level, the training will be assigned automatically.
Digital course material
