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 + 21% VAT

Location

Classroom Courses

Schedule

Guaranteed to run

Sessions in English
Contact us for more infoBook
Sessions in Dutch
16-17/01/2025Book
13-14/03/2025Book
12-13/05/2025Book
07-08/07/2025Book
29-30/09/2025Book
24-25/11/2025Book
Sessions in French
27-28/01/2025Book
24-25/03/2025Book
15-16/05/2025Book
14-15/07/2025Book
15-16/09/2025Book
20-21/10/2025Book

Share this course on

Book your training

Enter your information to confirm your booking.


    You might also be interested in

    Excel
    Excel 365 – Level 3 Power user
    Contact us for more info, 22 ...
    This 3-day course will train participants into becoming advanced Excel users by developing their skills regarding data handling, advanced functions,…
    Excel
    Excel 2019/365 Power Query Complete
    Contact us for more info, 03 ...
    Forget VBA and discover Power Query to automate your data collection. With this tool you can create complex queries without…
    Excel
    Excel 2019/365 – Level 2
    Contact us for more info, 24 ...
    Be able to work with the main functions. Nest functions. Master powerful analytics tools. Create models.
    Excel
    Excel 2019/365 – Macro
    Contact us for more info, 10 ...
    Do you want to save time on routine tasks in Microsoft Excel? Macros are the answer. In this course the…

    Prerequisite test

    Take the test

    Looking for a tailor made solution?

    Get started with personal training