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...

Goal Seek is great, but as things get more complex, Solver can help you in Excel Video 333. We’ll start...

Some of the real power of Solver comes when Solver can’t find a solution. I’ll show you what I mean in...

In Excel Video 335 we’ll talk about Solver reports and how to use those reports to document how Solver was...

Solver isn’t limited to just solving equations for a certain value, like 6 months in our examples so far. ...

If you like using Solver and want to save multiple scenarios with different constraints, watch Excel Video...

Excel Video 338 introduces Scenario Manager, a different way to manage scenarios in Excel. Scenario Manager...

Excel Video 339 introduces Scenario Summaries, a great way to see all of your scenarios in one place. Once...

Watch Excel Video 340 today to see two more tricks with Scenarios. You may never hear PivotTableGuy say this...

Excel Video 341 introduces Data Tables, another What-If tool that can be very helpful in Excel. The idea is...

Now that you’re familiar with Data Tables, Excel Video 342 shows how to vary two variables instead of just...

It’s hard to analyze and show three variables in two dimensional space with a Data Table, but Excel Video...

Excel Video 344 has three things you should know about Data Tables. The first tip is that the values in a...