Seminar S-EL0009 - Excel 2019: Analysing data: data tables and pivot tables

Target Audience

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

Objectives

  • Protect data
  • Share and collaborate effectively
  • Optimize data management

Content

  • Excel 2019 - Data tables:
    • database functionality with an Excel table.
  • Excel 2019 - Pivot tables:
    • set your data from a different angle: pivot tables and charts.
  • 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