EXCEL PRO TIP: Advanced Optimization with Solver

[@wayneedmondson1065]

Hi Chris.. great video on Solver. I use Goal Seek often and also Data Tables to test different input variables. Have not used Solver much, but looks very interesting. I'll definitely give it a try. Thanks and Thumbs up!!

[@johncallahan2447]

I just completed a Business Analytics Class and found the most difficult part was setting up the model pulling info from a paragraph containing the constraints. In your class, how much time is spent on organizing provided information and structuring it into the model?

[@theapexpredator157]

I need Solver to accept formulas in the Variable Cells Line so that it can select only certain cells within a range. Is this possible? If not, is there an alternate method to achieve my goal?