IT Training

Excel 2019/365 – Level 1

Being able to create tables and manage the calculations, formatting and page layout of the tables. The new Office interface, using the File tab (“Backstage”). Managing the Quick Access Toolbar. New tricks and techniques. One window per workbook

Who should attend this course?

This course is designed for people who want to learn how to create computer tables, whether it is for accounting or statistics


Know the Windows environment and master file management

Course objectives: To be able to create tables and manage them in terms of calculation, formatting and layout.


  • Understand the Excel environment (purpose, specific vocabulary, …)
  • Manipulate cells and spreadsheets (contiguous selections, discontinuous selections, rename, move, delete sheets …)
  • Enter data (alphabetical, numeric, use the copy 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


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


  • Format tables (characters, borders, alignments, number format, cell width and height, add or remove rows and columns, autoformat)


  • Creating and editing
  • + When and how to use the new 2019 charts (map, funnel, waterfall, hierarchical)

Layout and printing

  • Orient, adjust, header and footer, print area, …
  • Transform the file to PDF


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

Situational exercises + tips & tricks

Practical information


2 Days




€700,00 + 3% VAT


Classroom Courses


Guaranteed to run

English courses
22/9 - 23/9Book
French courses
20/1 - 21/1Book
10/2 - 11/2Book
17/3 - 18/3Book
21/4 - 22/4Book
19/5 - 20/5Book
23/6 - 24/6Book
25/7 - 26/7Book
25/8 - 26/8Book
22/9 - 23/9Book
20/10 - 21/10Book
24/11 - 25/11Book
08/12 - 09/12Book

Share this course on

Book your training

Enter your information to confirm your booking.

    Prerequisite test

    Looking for a tailor made solution?