Course Details Extension:
- Special functions in Excel
- Calculate max. resp. min. values with target value search and solver
- Interest calculation - linking worksheets and files
- Merge worksheets/workbooks
- Advanced matrix formulas (array formulas)
- Pivot tables (format and evaluate pivot data)
- Create project plan/ schedule with Gantt view (Gantt chart)
- Excel charts: Diagram types at a glance
The contents will be learned by working on practical examples by the course participants on their own laptops. Prerequisite for participation is an own laptop with an installed Excel version (from 2010). However, it is recommended to get the latest Excel version. This can be downloaded free of charge from www.office.com.
Only students who are able to attend one of the dates without interruption and who have already completed a basic course will be admitted to the course. Places will be allocated on a first come, first serve basis and a maximum of 20 people will be admitted to each event.
Registration: https://uni-wh.jobteaser.com/de/events/174431-excel-kurs-erweiterung
Registration deadline is May 24, 2023.