by Nate Moore | Apr 1, 2013 | Uncategorized
Excel Video 344 has three things you should know about Data Tables. The first tip is that the values in a Data Table can’t be manually changed. You can’t delete individual values either. The only way to get rid of values in a Data Table is to select all of the values...
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...