Online Course Guide of WHU –
Find all modules and courses of our degree programs.
Please use the filters below to select the term (spring or fall) as well as the respective program (BSc, MSc, MBA, Exchange, Doctoral) of your choice for an overview of all modules offered at WHU. The courses are listed under the modules. Please click on a module to see which courses are part of it. If you would like to find out more about a certain course, click on the name of the course to see detail information. The location of the lecture will be revealed after your course registration on myWHUstudies.
Spring term counts from January - August, fall term counts from September - December.
Important for Exchange Students: As the Full-Time and Part-Time MBA Programs utilize a modular course structure, the dates on which students begin and end the exchange are flexible. Please find here a chronological overview of the preliminary course offering for Fall and Spring.
Workshop: Using Excel for Financial Applications
(Please note that exchange students obtain a higher number of credits in the BSc-program at WHU than listed here. For further information please contact directly the International Relations Office.)
- Lookup-Functions (VLOOKUP / HLOOKUP)
- How to retrieve financial data
- Conditional Statements (IF / AND / OR)
We will use the Excel functions for the following applications (among others):
- Portfolio Optimization
- Performance Evaluation
- Option Pricing
By the time that students have completed the course they will be able to…
- Apply the Lookup-functions (VLOOKUP / HLOOKUP) in Excel
- Use Conditional Statements (IF / AND / OR) in Excel
- Apply the SOLVER-function to solve optimization problems related to finance
- Perform a Regression analysis in Excel
- Perform Simulation of financial data in Excel
- Download financial data into Excel
The following LinkedIn Learning Course covers a lot of the topics:Excel: Advanced Formulas and Functions
As a WHU student you can access LinkedIn Learning through the Library:Professional Development
For students with no or little prior knowledge in finance that still want to take this course, I recommend the following book: Bodie, Kane & Marcus (2021): Investments; McGraw-Hill.