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.

Spring 2022  ›  Bachelor of Science  ›  Bachelor of Science - 6th Semester  ›  Free Elective

Workshop: Using Excel for Financial Applications

Course Code:
FIN611
Lecturers:
Juniorprof. Dr. Simon Straumann
Course Type:
BSc Free Elective
Week Hours:
1,0
Term:
Spring 2022
Language:
Englisch
Credits:
1.0
(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.)
The main focus of the curse are the following topics
  • Lookup-Functions (VLOOKUP / HLOOKUP)
  • Solver-Function
  • How to retrieve financial data
  • Conditional Statements (IF / AND / OR)
  • Regression
  • Simulations

We will use the Excel functions for the following applications (among others):

  • Portfolio Optimization
  • Performance Evaluation
  • Option Pricing
Date
Time
Friday, 28/01/2022
03:30 PM till 06:45 PM
Friday, 04/02/2022
03:30 PM till 06:45 PM
Friday, 11/02/2022
03:30 PM till 06:45 PM
The course is designed as a computer workshop. Guided by the lecturer, students will solve specific problems in finance using Excel. Students will learn some of the essential Excel features and advance their prior knowledge in finance theory by implementing finance theory into practice using Excel.

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 main resources for learning are lecture slides and exercises. There is no required textbook for the course.

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.

The course is designed as a computer workshop. Guided by the lecturer, students will solve specific problems in finance using Excel.
Students are required to have access to a computer with an internet connection and MS Office (Excel). Basic knowledge of Excel (entering values into cells, etc.) is expected.