Investment Analysis in Microsoft Excel: Risk/Return Calculations and Portfolio Management

April 18 - 19, 2018
EUR 1,400
Prague, NH Hotel Prague
Andreas Steiner

Course Overview:
This course gives an overview of applying Excel in a most efficient manner for typical calculations in investment analysis and portfolio management. Delegates will be introduced to some of the less widely known but highly useful built-in functions. Spreadsheet templates are used in group exercises to solve case study - like problems. The focus of the course is to deliver practical value for working professionals. The calculations discussed in the course are typical examples encountered in performance measurement, risk management and portfolio management.

The training consists of classroom-based teaching combined with group exercises (four per day).

Who should attend?
The course is not only for specialists but for a wider audience including investment managers, asset management executives of all levels, institutional investors and research analysts. This course has been designed for the benefit of: The course assumes a general familiarity with financial markets, instruments and investment portfolios. A basic understanding of statistical and mathematical concepts is an advantage.

Delegates will receive colour printouts of all slides and electronic access to Excel spreadsheets used during the course.

The workshop will be highly practical and hands-on. Participants are required to bring a notebook with MS Excel. Course files will be distributed during and after the workshop.

Desktop Version