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