Install Excel Data Analysis ToolPak and Solver Add-In | Financial Modeling Tutorials

Published: 25 March 2018
on channel: FactorPad
7,726
85

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!


Watch video Install Excel Data Analysis ToolPak and Solver Add-In | Financial Modeling Tutorials online, duration hours minute second in high quality that is uploaded to the channel FactorPad 25 March 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 7,726 times and liked it 85 visitors.