Séminaire 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

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


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 

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

Sessions

08.12.2024
Zugang zum E-Learning für 6 Monate nach der Einschreibung
E-Learning
Online
75 €
08.12.2024
Access to e-learning for 6 months after subscription
E-Learning
Online
75 €
08.12.2024
Accès au e-learning pendant 6 mois après inscription
E-Learning
Online
75 €