Database Query in Excel After viewing this video training you will know how to work with the Solver to deal with multi-variables mathematical problems that might require optimization. You will learn how to define the mathematical model, declare the idependent variables, the restrictions to those variables. You will also ve able to save the results as scenarios in the Scenario Manager. The whole video takes less than 20 minutes. The video is developed using the english version of Excel 2003, but the same procedure applies for Excel Xp.