Learn the necessary steps required for achieving a diversified portfolio. You will be introduced to concepts such as variance, standard deviation, and correlation. You will also learn about the efficient frontier as you develop skills in writing basic functions and producing graphs in Excel.
Select the Slide Deck for a guided assignment on this topic. Then use the data provided in the Spreadsheet to try the exercise yourself. The Link to Platform enables you to extend this assignment to different companies and/or date ranges. Your instructor may have additional guidance regarding the use of this Teaching Tool.