An introduction to Linear Algebra and Arrays in Excel | Financial Modeling Tutorials
A financial modeling tutorial and introduction to Linear Algebra basics in Excel array formulas including benefits of matrix algebra for portfolio optimization and risk management of stock portfolios for Quant 101 data analytics course.
For the video transcript and Excel cell formulas see:
https://factorpad.com/fin/quant-101/l...
Zoom straight to the section you are interested in here:
00:53 - Video Outline
01:32 - Step 1 - Excel Array Formulas
07:05 - Step 2 - Tips for Using Excel Array Formulas
09:49 - Step 3 - Array Structures in Linear Algebra
12:25 - Step 4 - Calculate Return using an Array Function
14:45 - Summary
16:29 - Step 5 - Next: Array Math Operations
For the outline to the series see:
https://factorpad.com/fin/quant-101/q...
See how else you can advance your career at:
https://factorpad.com
Happy Learning!
Watch video An introduction to Linear Algebra and Arrays in Excel | Financial Modeling Tutorials online without registration, duration hours minute second in high quality. This video was added by user FactorPad 24 May 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,367 once and liked it 58 people.