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

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
    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 Power Pivot
    By the end of this course, you will be able to determine which of the two tools, PivotTables and PowerPivot,…
    ExcelExcel
    Excel 2019/365 – Level 2
    Be able to work with the main functions. Nest functions. Master powerful analytics tools. Create models.

    Prerequisite test

    Take the test

    Looking for a tailor made solution?

    Get started with personal training