Excel 2019: Complex tables: advanced calculations, simulations and audits (S-EL0007)

Who is the training for?

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

Duration

2,00 hours(s)

Language(s) of service

Next session

Price

75.00€

Prerequisites

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

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.

Excel 2019 - Advanced calculations:
- find the right function for your calculation.
Excel 2019 - Simulation abd audits:
- simulation;
- spreadsheet;
- audit.
Office 2019 - Use cases.
Excel 2019 and Office 365 versions Reference book (digital course material).
Excel 2019 - Table creation basics.