Whether for internships - regardless of the industry or position -, as a potential founder or even just for accounting in a shared flat, an advanced basic knowledge of Microsoft's spreadsheet software is essential nowadays and can save you a lot of work if used correctly. After the basic course and the first basics, participants can further develop their Excel skills in this advanced course - with practical exercises on their own laptop.
Course details Extension:
- Special functions in Excel
- Calculating maximum and minimum values with target value search and solver
- Interest calculation
- Linking worksheets and files
- Merging worksheets/workbooks
- Advanced matrix formulas (array formulas)
- Pivot tables (formatting and evaluating pivot data)
- Create project plan / schedule with Gantt view (bar chart)
- Excel charts: Overview of chart types
The content will be learned by the course participants working on practical examples on their own laptops.
Instructor: Julian Graßhoff, denkleister
The course is aimed at all UW/H students. The prerequisite for participation is your own laptop with an installed Excel version (from 2010). However, we recommend getting the latest Excel version. Every student can download this free of charge at www.office.com.
Only students who can attend one of the dates without interruption will be admitted to the course.
The course takes place in presence. A maximum of 20 people are admitted. Places will be allocated on a first come, first serve basis.
Registration is required. The registration deadline for the extension course is 17.06.2026.
Important note: Registration is binding. A cancellation fee of €30 will be charged for unexcused absences. This regulation has proven its worth, as in the past it has happened that courses were considered fully booked and interested students could no longer get a place. In reality, however, some registered students were unable to attend without canceling, leaving places unused.