Excel 2019/365 - Level 1

Unternehmensübergreifende Weiterbildung

An wen richtet sich die Weiterbildung?

Beginner or occasional Excel users.

Dauer

2,00 Tag(e)

Sprache(n) der Dienstleistung

EN FR

Nächster Termin

07.05.2026
Ort
Capellen

Preis

900,00€

Voraussetzungen

Be familiar with the Windows environment and able to manage files efficiently.

Ziele

Learn how to correctly design worksheets and analysis tables, and master the essential commonly used features.

Inhalt

New Excel functionalities in this version

DIFFERENCES BETWEEN Excel WEB APP and Excel DESKTOP APP
Sign in to the Office 365 portal.
CHOOSE THE RIGHT STORAGE DRIVE FOR YOUR WORKBOOKS
Classical : on a file server or the hard drive of a device.
365 : Personal OneDrive / Shared OneDrive / SharePoint-Teams.

Introduction

  • Understand the Excel environment (purpose, specific vocabulary, …)
  • Manipulate cells and spreadsheets (selections of adjacent or non-adjacent cells, how to rename, move, delete worksheets, …).
  • Enter data (alphabetical, numerical, use of the fill handle, custom lists, …).

Choose the storage drive for your workbooks

  • Classic: On a file server or a machine’s hard drive
  • 365: OneDrive Personal / OneDrive Shared / SharePoint-Teams

Calculation

  • Create formulas
  • Use functions (autosum, average, root, round, …)
  • Use absolute, relative and mixed references

Formatting

  • Format tables (font, borders, alignment, number format, cell width and height, addition or deletion of rows and columns, automatic formatting).

Charts

  • Create and edit charts

Layout and printing

  • Orientation, adjustment, header and footer, printing area, …
  • Create a PDF document

Databases

  • Properly structure a data table
  • Use automatic sorts and filters
  • Apply the Table tool

Practical Exercise Scenario’s + tips & tricks

Behandelte Themen

Proper structuring of tables (best practices)
Basic formulas and calculation functions
Data formatting
Creation of simple charts
Page setup and printing of Excel documents
This level provides the essential foundations for professional use of Excel.

Nächster Termin

Datum
Stadt
Sprache und Preis
07.05.2026

08.05.2026
Capellen
EN 900,00€
07.05.2026

08.05.2026
Capellen
FR 900,00€
16.07.2026

17.07.2026
Capellen
EN 900,00€
16.07.2026

17.07.2026
Capellen
FR 900,00€
17.09.2026

18.09.2026
Capellen
EN 900,00€
17.09.2026

18.09.2026
Capellen
FR 900,00€
19.11.2026

20.11.2026
Capellen
EN 900,00€
19.11.2026

20.11.2026
Capellen
FR 900,00€

Veranstaltungsart

Classroom courses (virtual training also available).

Diese Weiterbildungen könnten Sie interessieren

EN
Tag
Auf Anfrage
Logiciel - Projektmanagementsoftware - Software MS-Project
EN
Tag
Logiciel - Grafiksoftware - Software CAD/CAM - Software Autocad