Jump directly to the content of the page

Intranet Uni WH | Eventdetail

Menü schließen

Events

at UW/H

Events

at UW/H

Advanced Excel course June 2025

Time
Location Mainbuilding, E.110, Alfred-Herrhausen-Straße 50, 58455 Witten
Organizer UW/H-Career Service
Note nur für Studierende

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 max. and min. 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

Participation requirements:

The prerequisite for participation is your own laptop with an installed Excel version (from 2010). However, it is advisable to obtain the latest Excel version. Every student can download this free of charge.

Only students who can participate without interruption and 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 per course.

Registration deadline: Interested parties can register until June 04, 2025 via the Career Service.