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.

• Master the basics of Excel 2019: 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.

• 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

Assessment test and training - Depending on the learner's level, the training will be assigned automatically.

Digital course material