Excel 2019/365 - Level 1

Beginner or occasional Excel users.

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

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

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

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.

Classroom courses (virtual training also available).