Class YearFinanceFirst YearsJuniorsSeniorsSophomores

Excel for Investment Professionals

Instructor: Michael McDonald

Do you manage a portfolio of stocks or securities? Microsoft Excel offers professionals in the investment industry with a bevy of tools that they can use to make sound investments. In this course, learn how to leverage these tools and perform key investment-related activities in Excel, including investment evaluation and analysis on a stock or portfolio. Professor Michael McDonald provides an overview of the major tasks in the investment industry, and then digs into how to do single stock investment analysis. He also goes over how to compute expected returns on a stock and a portfolio, value a bond in Excel, compute performance evaluation metrics, and more.

Learn More