en
nlfr
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.

    You might also be interested in

    ExcelExcel
    Excel 2019/365 – Level 2
    20/1 - 21/1, 17/2 - 18/2, 17 ...
    Dealing with the important basic functions. Nesting functions. Using the powerful analysis tools. Creating automated templates and macros. The new…
    ExcelExcel
    Excel 2019/365 – Macro
    14/1, 11/2, 11/3, 22/4, 20/5 ...
    Do you want to save time on routine tasks in Microsoft Excel? Macros are the answer. In this course the…
    ExcelExcel
    Excel 2019/365 Power Pivot
    13/1, 10/2, 10/3, 21/4, 19/5 ...
    By the end of this course, you will be able to determine which of the two tools, PivotTables and PowerPivot,…
    ExcelExcel
    Excel 2019/365 Power Query – Level 1
    17/1, 07/3, 09/5, 04/7, 10/1 ...
    Forget VBA and discover Power Query to automate your data collection. This tool allows you to create complex queries without…

    Prerequisite test

    Take the test

    Looking for a tailor made solution?

    Get started with personal training