Excel 2019 – Analysing data: data tables and pivot tables

Course goals

This course aims to enable you to better exploit your data tables and to create pivot tables. After taking this course, you will be able to easily manage data tables and pivot tables.

Prerequisites

Target audience:
Users who have mastered the essential commands and wish to move towards more advanced techniques.

Level required:
The essential commands must be mastered in order to access Excel’s advanced techniques without difficulty.

Course goals

MEDIAplus eLearning
This module offers interactive training consisting of 10 training videos, 10 exercises and 2 additional resources.
Excel 2019 – Data tables
• Database functionality with an Excel table

MEDIAplus eLearning
This module offers interactive training consisting of 8 training videos, 8 exercises and 1 additional resource.
Excel 2019 – Pivot tables
• Set 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

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 27 training videos, 27 exercises and 6 additional resources.
Excel 2019 – Table creation basics