Excel 2021 – Complex tables: advanced calculations, simulations and audits
E-Learning MEDIAplus elearning™
1h35
FR - ES - DE - EN - NL
En_EB31-632
Want to offer this online course to your learners?
Our teams are here to help.
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 moreCourse 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 11 training videos, 11 exercises.
Excel 2021 – Advanced calculations
• Find the right function for your calculation
MEDIAplus elearning
This module offers interactive training consisting of 7 training videos, 7 exercises.
Excel 2021 – Simulations and audits
• Simulation
• Spreadsheet audit
Video
This module offers to view a video lasting 23 minutes.
Microsoft Office: use cases – Excel, Word or PowerPoint with a Microsoft 365 subscription
• The Office suite with or without an Microsoft 365 subscription: what are the differences?
• Creating and saving Office files in OneDrive, SharePoint Online or Teams
• Editing an Office file from OneDrive, SharePoint or Teams
• Sharing Office files with other contributors or people from outside your organisation
• Co-editing a file
Additional book
This module includes digital course material.
Excel 2021 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 2021 – Table creation basics