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

À qui s'adresse la formation?

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

Durée

2,00 heure(s)

Langues(s) de prestation

Prochaine session

S'inscrire

Prix

75.00€

Prérequis

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

Objectifs

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.

Contenu

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.