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

Target Audience

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

Objectives

  • Mastering advanced calculations
  • Performing simulations and audits
  • Creating and managing complex tables

Content

  • 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.

Prerequisites

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

Sessions