Excel pivot tables and list analysi - Microsoft Office Training

Beschreibung

Seminar content
Editing Excel lists (tables), use of validity rules
Defining cell ranges as a table
Filtering (auto and special filters) and sorting data
Possibilities of list evaluations
Evaluate lists by partial results
Evaluate data using formulas (database functions)
Pivot tables: Basics of creating, editing existing pivot tables
Selecting and grouping pivot data, using user-defined formulas in pivot tables, evaluating by month, quarter, year
Summarizing pivot tables
Visualize with pivot charts
Use results for further calculations and evaluations
Import and export data of different formats, especially within Office
Tips and tricks

Translated with www.DeepL.com/Translator (free version)

Ziel

/

Anforderungen an die Teilnehmer

Good knowledge of Microsoft Office Excel

Teilnehmer

Microsoft Office Excel user