Excel (2024 and Microsoft 365 versions) – Complex tables: advanced calculations, simulations and audits

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

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.

MEDIAplus elearning
This module offers interactive training consisting of 11 training videos, 11 exercises.
Excel (2024 and Microsoft 365 versions) – Advanced calculations

• Find the right function for your calculation – Theme
  • Lookup tables and functions
  • Text functions
  • Time calculations
  • Date calculations
  • Conditional arithmetic functions
  • Logical functions with several conditions and responses
  • Dynamic array functions
  • Calculating with copied values
  • Consolidation
  • Financial functions
  • Creating a custom function

MEDIAplus elearning
This module offers interactive training consisting of 7 training videos, 7 exercises.
Excel (2024 and Microsoft 365 versions) – Simulations and audits

• Simulation – Theme
  • Double entry data table
  • Goal seek
  • The Solver
  • Managing scenarios
• Spreadsheet audit – Theme
  • Detecting errors
  • Evaluating formulas
  • The Watch Window

Additional MEDIAplus elearning content
This module offers interactive training consisting of 27 training videos and 27 exercises.
Excel (2024 and Microsoft 365 versions) – Table creation basics