
Goal Seek, Solver and Scenarios Playlist
Excel Video 331 Introducing Goal Seek
Now that you’re a Pivot Table Master, Excel Video 331 introduces an Excel feature I’ve been waiting to...
Excel Video 332 Goal Seek Part 2
Excel Video 332 has more Goal Seek examples. I’ll also spend a minute demonstrating how complicated your...
Excel Video 333 Introducing Solver
Goal Seek is great, but as things get more complex, Solver can help you in Excel Video 333. We’ll start...
Excel Video 334 Changing Constraints in Solver
Some of the real power of Solver comes when Solver can’t find a solution. I’ll show you what I mean in...
Excel Video 335 Solver Reports
In Excel Video 335 we’ll talk about Solver reports and how to use those reports to document how Solver was...
Excel Video 336 Solving for Min and Max
Solver isn’t limited to just solving equations for a certain value, like 6 months in our examples so far. ...
Excel Video 337 Loading and Saving Solver Scenarios
If you like using Solver and want to save multiple scenarios with different constraints, watch Excel Video...
Excel Video 338 Introducing Scenario Manager
Excel Video 338 introduces Scenario Manager, a different way to manage scenarios in Excel. Scenario Manager...
Excel Video 339 Scenario Manager Summary
Excel Video 339 introduces Scenario Summaries, a great way to see all of your scenarios in one place. Once...
Excel Video 340 Scenario Manager Pivot Table and Merging Scenarios
Watch Excel Video 340 today to see two more tricks with Scenarios. You may never hear PivotTableGuy say this...
Excel Video 341 Introducing Data Tables
Excel Video 341 introduces Data Tables, another What-If tool that can be very helpful in Excel. The idea is...
Excel Video 342 Data Tables with Two Variables
Now that you’re familiar with Data Tables, Excel Video 342 shows how to vary two variables instead of just...
Excel Video 343 Data Tables with Three Variables
It’s hard to analyze and show three variables in two dimensional space with a Data Table, but Excel Video...