by Nate Moore | Mar 27, 2013 | Uncategorized
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...
by Nate Moore | Mar 25, 2013 | Uncategorized
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...
by Nate Moore | Mar 20, 2013 | Uncategorized
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...
by Nate Moore | Mar 18, 2013 | Uncategorized
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...
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...
