Excel data tables - 3 things you should know.
Instead of testing each variable individually, make a What-if analysis data table and observe all possible outcomes with a quick glance! You have built a complex formula dependent on multiple variables and want to know how changing those inputs changes the results. Learn how to create a one-variable and two-variable table to see the effects of one or two input values on your formula, and how to set up a data table to evaluate multiple formulas at once. The tutorial shows how to use data tables for What-If analysis in Excel.
