Excel 2019 – Mastering the essentials

Course goals

Discover Excel 2019 and Office 365 versions, master data entry and formula, determine the format and layout of your tables and charts. You will learn how to manage long tables by filtering and sorting and you will be able to synthetize data using pivot tables.

Prerequisites

Target audience:
Any beginners or users with basic knowledge who wish to master Excel’s essential commands.

Level required:
No knowledge of Excel is necessary. The user just needs to be acquainted with using the keyboard and mouse.

Course goals

MEDIAplus eLearning
This module offers interactive training consisting of 45 training videos, 45 exercises and 5 additional resources.
Excel 2019 – Level 1: Essential skills
• Get started in Excel
• Set out your first Excel calculations
• Look good with easy formatting
• Print an attractive document
• Increase your efficiency
• Multiple worksheets and various views

MEDIAplus eLearning
This module offers interactive training consisting of 60 training videos, 60 exercises and 5 additional resources.
Excel 2019 – Level 2: Intermediate skills
• Move on to more complex tables
• Let charts explain your data
• Create striking charts
• Illustrate your data
• Database functionality with an Excel table
• See your data from a different angle: pivot tables and charts

Video
This module offers to view a video lasting 22 minutes.
Office 2019: use cases
• Excel, Word or PowerPoint with an Office 365 subscription

Video
This module offers to view a video lasting 55 minutes.
Excel 2019: use cases
• Implementing quality control
• Analysing a library’s attendance levels
• Monitoring the budget
• Minimising costs

Additional book
This module includes digital course material.
Excel 2019 and Office 365 versions – Reference book

Additional MEDIAplus eLearning content
This module offers interactive training consisting of 42 training videos, 42 exercises and 5 additional resources.
Excel 2019 – Level 3: Advanced skills