Beginner
Using Excel Solver for Basic Optimization Problems
A hands-on introduction to Excel's Solver add-in for readers who want to move beyond manual trial and error. You will set up an objective, decision variables and constraints for a real portfolio allocation problem, run Solver end to end, and learn to read its sensitivity report so you can trust the answer it gives you.
Excel SolverOptimizationPortfolio AllocationLinear Programming
MODULES
3
DURATION
4 Hours
TRACK
Quantitative Finance
What You'll Master
What optimization means and when Solver is the right tool for the job
How to enable Solver and structure a spreadsheet around an objective, decision variables and constraints
How to build and solve a portfolio allocation problem in Excel from scratch
How to read Solver's sensitivity report, including shadow prices and binding constraints
How to recognize and fix the most common reasons Solver fails to find a solution
Access Level
LEARNER
Everything included
Full Text Playbooks
Actionable Exercises
Mobile Reading Mode
Lifetime Updates