The goal of this course is that students are able to solve practical financial problems with Excel, using spreadsheet functions as well as VBA programming. Students will also have an increased familiarity with methods and concepts from finance.

More information is available on Moodle.

Familiarity with basic concepts from financial economics (discounting, risk and return, option pricing) is important. The course is structured such that bachelor students can acquire such knowledge by parallel attendance of the lecture Finanzierung.  For master students, the courses Asset Pricing and Derivatives would together also provide the necessary background.

You will need access to a computer/laptop with Microsoft Excel for this course. As a student, you can get Excel for a small fee of 4.39€  see this link (in German only; we are happy to help if needed).

If you are an Excel novice watch one of our introduction videos for Excel in English or German  (will be available via Moodle). Most students in the course will have some basic Excel literacy. If you struggle with the preparation tasks that we wil ask you to solve, it is likely that you benefit from investing some more time into getting more familiar with Excel.