CAS Campus Logo
Version 6.2.44
(01)
Startseite | Login
Sie sind nicht angemeldet.
Nach oben
[i18n:label.footer.ownertext]
Hilfe

Financial Modeling with Excel (MiE & MiM)

.
Organisatorische Informationen Kursbeschreibung
.

generalinformation open Allgemeine Angaben

Lehrveranstaltungsnummer:
0100108
Kursbezeichnung (Deutsch):
Financial Modeling with Excel (MiE & MiM)
Kursbezeichnung (Englisch):
Financial Modeling with Excel (MiE & MiM)
Veranstaltungsart:
MSc Kurs
Semester:
FS 2019
Tooltip Help Geplante Lernergebnisse und Kompetenzen (Deutsch):
In this course, students will learn how to implement financial models in Excel, how to use the functions and formulas to their advantage, and how to build meaningful models. Students will also learn to optimize with the Solver function: the most common tool used in making business decisions.

An important aspect of the course is gaining practical experience in formatting, visualization and analysis of financial data. By numerous examples the students will gain insides on how to feed models with financial data and answer basic questions in portfolio management and asset pricing. At the end of the course students should be able to visualize financial data, optimize portfolios and price options.

Tooltip Help Geplante Lernergebnisse und Kompetenzen (Englisch):
In this course, students will learn how to implement financial models in Excel, how to use the functions and formulas to their advantage, and how to build meaningful models. Students will also learn to optimize with the Solver function: the most common tool used in making business decisions.

An important aspect of the course is gaining practical experience in formatting, visualization and analysis of financial data. By numerous examples the students will gain insides on how to feed models with financial data and answer basic questions in portfolio management and asset pricing. At the end of the course students should be able to visualize financial data, optimize portfolios and price options.

.