Excel 2019 – Complex tables: advanced calculations, simulations and audits

E-Learning MEDIAplus elearning™

Excel 2019 Tableaux complexes

2h35

FR - ES - DE - EN - NL

3EB31-532

Want to offer this online course to your learners?
Our teams are here to help.

Contact us!
Download the brochure

MEDIAplus elearning is an online training solution, unique in the market. Learning through practice, directly within the studied app and with immediate results analysis and solution.

Find out more
Download the brochure

Course goals

This course aims to show you the extent of the calculation possibilities in Excel: advanced calculations, simulations and audits. After taking this course, you will be able to easily create complex 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 12 training videos, 12 exercises.
Excel 2019 – Advanced calculations
• Find the right function for your calculation

MEDIAplus eLearning
This module offers interactive training consisting of 7 training videos, 7 exercises.
Excel 2019 – Simulations and audits
• Simulation
• Spreadsheet audit

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