by Nate Moore | Mar 11, 2013 | Uncategorized
Excel Video 339 introduces Scenario Summaries, a great way to see all of your scenarios in one place. Once you’ve built several scenarios, it’s easy to switch between each scenario. Today we’ll create a Scenario Summary where you can compare the results of each...
by Nate Moore | Mar 6, 2013 | Uncategorized
Excel Video 338 introduces Scenario Manager, a different way to manage scenarios in Excel. Scenario Manager is another tool in the What-If Analysis section of the Data tab. We can use Scenario Manager to keep track of what happens when we change variables in an...
by Nate Moore | Mar 4, 2013 | Uncategorized
If you like using Solver and want to save multiple scenarios with different constraints, watch Excel Video 337 to learn how to load and save Solver scenarios. To save a Solver scenario, it’s just a matter of giving Excel a range of cells to save the data in. To load a...
by Nate Moore | Feb 27, 2013 | Uncategorized
Solver isn’t limited to just solving equations for a certain value, like 6 months in our examples so far. Solver can also find minimum and maximum solutions, as we’ll see in Excel Video 336. This time instead of trying to pay for our equipment in 6 months, the...
by Nate Moore | Feb 25, 2013 | Uncategorized
In Excel Video 335 we’ll talk about Solver reports and how to use those reports to document how Solver was set up. The first thing to say about these reports is that they’re way beyond the scope of what I try to do in these Excel Videos. If you’re interested in...