Excel Aufbau - Microsoft Office Training

Beschreibung

Seminar content

Deepening of the basic knowledge, working out questions from the practice of the participants
Complex formulas and functions in various tasks, such as reference function, working with conditions, date calculations, IF function, nested function (if, if-and, if-or), sum-if, sum-when, count-when, count-when
Linking worksheets and files
Multiple operations, target value search (what-if analyses)
Consoling (summarizing) and structuring tables
Special functionalities such as conditional formats, validity rules, user-defined formats, protecting cells and sheets
Understand important presets and change them as needed
Compatibility with previous versions, overview of file formats
Tips and tricks
Database functionalities in Excel: selecting (auto and special filters), sorting, evaluating lists (tables)
Data evaluation with pivot tables
Creating and editing complex diagrams
Calculating with names

Ziel

/

Anforderungen an die Teilnehmer

Microsoft Excel basic knowledge

Teilnehmer

Microsoft Office Excel user