Excel Aufbau - Microsoft Office Training

Description

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

Aim

/

Participant requirements

Microsoft Excel basic knowledge

Participant

Microsoft Office Excel user