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

Prerequisites

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.

Introduction

  • 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

Calculate

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

Formatting

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

Charts

  • 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

Databases

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

Situational exercises + tips & tricks

Practical information

Duration

2 Days

Languages

FR / NL

Price

€700,00 + 21% VAT

Location

Classroom Courses

Schedule

Guaranteed to run

Dutch courses
24/1 - 25/1Book
21/2 - 22/2Book
14/3 - 15/3Book
21/4 - 22/4Book
16/5 - 17/5Book
20/6 - 21/6Book
18/7 - 19/7Book
22/8 - 23/8Book
19/9 - 20/9Book
17/10 - 18/10Book
21/11 - 22/11Book
05/12 - 06/12Book
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?