en
nlfr
IT Training

Excel 2019/365 – Level 1

Be able to create tables and manage the calculations, formatting and page layout of the tables.

Who should attend this course?

This course is intended for professionals who will be required to make tables, whether in the accounting or statistics field.

Prerequisites

Be famiiar with Windows environment and master file management

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

New Excel functionalities in this version

  • Neww charts: MAP, FUNNEL, WATERFALL, HIERARCHICAL.
  • Accurate selection and improved autocomplete.
  • 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

  • Creatie and edit charts
  • When and how to use the new 2019 charts (map, funnel, waterfall, hierarchical)

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

Practical information

Duration

2 Days

Languages

FR / NL

Price

€800,00 + 21% VAT

Location

Classroom Courses

Schedule

Guaranteed to run

Sessions in Dutch
23/1 - 24/1Book
20/2 - 21/2Book
13/3 - 14/3Book
20/4 - 21/4Book
15/5 - 16/5Book
19/6 - 20/6Book
17/7 - 18/7Book
21/8 - 22/8Book
18/9 - 19/9Book
16/10 - 17/10Book
20/11 - 21/11Book
04/12 - 05/12Book
Sessions in French
19/1 - 20/1Book
09/2 - 10/2Book
16/3 - 17/3Book
20/4 - 21/4Book
22/6 - 23/6Book
27/7 - 28/7Book
24/8 - 25/8Book
21/9 - 22/9Book
19/10 - 20/10Book
23/11 - 24/11Book
30/11 - 01/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 Power Pivot
    12/1, 09/2, 09/3, 20/4, 17/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
    18/1, 08/3, 10/5, 05/7, 11/1 ...
    Forget VBA and discover Power Query to automate your data collection. This tool allows you to create complex queries without…
    ExcelExcel
    Excel 2019/365 Power Query – Level 2
    10/2, 21/4, 14/7, 15/9, 16/1 ...
    Thanks to a functional and non-developmental interface, Power Query facilitates the work of those who need to analyse data from…
    ExcelExcel
    Excel 2019/365 Power Query Complete
    23/2 - 24/2, 11/5 - 12/5, 06 ...
    Forget VBA and discover Power Query to automate your data collection. With this tool you can create complex queries without…

    Prerequisite test

    Take the test

    Looking for a tailor made solution?

    Get started with personal training