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

publish

Languages

FR / NL

Price

€ 800 + 21% VAT

Location

Classroom Course

Schedule

Guaranteed to run

Sessions in English
Contact us for more infoBook
Sessions in Dutch
23 - 24/1/2024Book
20 - 21/2/2024Book
13 - 14/3/2024Book
20 - 21/4/2024Book
15 - 16/5/2024Book
19 - 20/6/2024Book
17 - 18/7/2024Book
21 - 22/8/2024Book
18 - 19/9/2024Book
16 - 17/10/2024Book
20 - 21/11/2024Book
04 - 05/12/2024Book
Sessions in French
18 - 19/1/2024Book
08 - 09/2/2024Book
14 - 15/3/2024Book
18 - 19/4/2024Book
16 - 17/5/2024Book
20 - 21/6/2024Book
25 - 26/7/2024Book
22 - 23/8/2024Book
19 - 20/9/2024Book
17 - 18/10/2024Book
21 - 22/11/2024Book
05 - 06/12/2024Book

Share this course on

Book your training

Enter your information to confirm your booking.

    You might also be interested in

    ExcelExcel
    Excel 365 – Level 3 Power user
    Contact us for more informat ...
    This 3-day course will train participants into becoming advanced Excel users by developing their skills regarding data handling, advanced functions,…
    ExcelExcel
    Excel 2019/365 – Level 2
    Contact us for more info, 18 ...
    Be able to work with the main functions. Nest functions. Master powerful analytics tools. Create models.
    ExcelExcel
    Excel 2019/365 – Macro
    Contact us for more info, 12 ...
    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
    Contact us for more info, 11 ...
    By the end of this course, you will be able to determine which of the two tools, PivotTables and PowerPivot,…

    Prerequisite test

    Take the test

    Looking for a tailor made solution?

    Get started with personal training