Select Page

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 343 has some ideas on how you might do it. The first way to analyze three variables is to simply change the third variable and watch as the Data Table changes. If...

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 one. As we discussed in Excel Video 341, the biggest trick is to make sure that you get the formula in the right cell, but once you do, it’s easy to create a...

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 to create a formula using some variables. A Data Table will take a group of rows and/or columns and insert each value in the group into the formula. The result...

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 again, but I actually like the Scenario Summary better. Both the Summary and the Pivot Table take some renaming like we did in Excel Video 339, but the Summary...

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