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, duration hours minute second in high quality that is uploaded to the channel FactorPad 24 May 2018. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 3,367 times and liked it 58 visitors.
