Install Excel Data Analysis ToolPak and Solver Add-In | Financial Modeling Tutorials
A financial modeling tutorial on installing Excel Data Analysis ToolPak and Excel Solver Add-In plus advantages and disadvantages of spreadsheets for quantitative portfolio management and how to download a sample data file and scale with programming beyond Quant 101.
Find the video script with all installation instructions here:
https://factorpad.com/fin/quant-101/s...
Zoom to the section you are interested in:
01:54 - Step 1 - Why a Spreadsheet?
05:12 - Step 2 - Versions of Excel
05:55 - Step 3 - Install Add-Ins
09:10 - Step 4 - Data set
13:17 - Step 5 - Why not programming?
17:09 - Step 6 - Next: Returns calculations
Find an outline of the Quant 101 Series of 30 videos here:
https://factorpad.com/fin/quant-101/q...
Don't lose this valuable resource, subscribe today!
https://factorpad.com
Happy Learning!
