Excel Forum
Similar Content
Error bars in Charts in Excel
Tutorial: How to add, manage, and remove error bars in charts in Excel. Error bars allow you to sh...
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...
Formula to Get the Last Value from a List in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Array Formula Series 14.3 Portfolio Standard Deviation


See how to create array formulas for Portfolio Return & Standard Deviation. See the array functions: MMULT, COLUMN, TRANSPOSE. See how to do this given different assumed states of the future economy.

See how to use probability, stock weights and assumed stock returns to calculate Portfolio Return & Standard Deviation.

See of to use the MMULT to matrix algebra. See of to use the COLUMN and TRANSPOSE functions to create a vertical array of ones.

In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.





Got a Question? Ask it Here in the Forum.