Abstract
This paper presents a simple method for teaching the Markowitz Portfolio Optimization topic. The use of Microsoft Excel or Corel Quattro Pro enables students and investors who do not possess a great deal of mathematical and programming expertise to identify meanvariance efficient portfolios which consist of more than two assets. Through this hands-on learning experience, students achieve a deeper understanding of the theory. The exercise also gives the students an eye opening lesson on the practical usability of spreadsheets.
Recommended Citation
(2026)
"An Excel-Based Approach for Teaching Markowitz’s Portfolio Optimization Theory,"
Journal of Economics and Finance Education: Vol. 16:
Iss.
2, Article 4.
Available at:
https://scholarship.rollins.edu/jefe/vol16/iss2/4
