Use an Excel Data Table to See Effect on Multiple Formulas
Excel Data Tables are part of the “What-if” Analysis group of tools and commands. In this lesson, I demonstrate how to use a one-input Data Table to show how substituting a series of inputs effects three separate formulas. This is a powerful – and easy – way to get answers to a series of “What-if” questions.
2-Input Data Table
Two-Input Data Table
I know that as I learned how to construct Data Tables, it was a lot easier for me to “see” how to set them up rather than to “read about” how they are set up. You can put your series of substitute values in either the “Column running down” or the “row going across” in the data table. To include the three formulas in the Data Table, I simply included “Links” to the formulas in the original assumptions table.
I cover “What-if” data analysis extensively on my DVD, “The 50 Best Tips for Excel 2007.” – Click here to add it to your secure shopping cart!
Learn how you can “Master Excel in Minutes – Not Months!”
Use an Excel Data Table to See Effect on Multiple Formulas [ 4:29 ] Play Now | Play in Popup | Download (258)
