MICROSOFT EXCEL DATA ANALYSIS TAB HOW TO
MICROSOFT EXCEL DATA ANALYSIS TAB SERIES

To check different options, you've built the following compound interest calculator where: Suppose you are considering depositing your savings in a bank, which pays 5% interest that compounds monthly. To help you better understand this feature, we are going to follow a specific example rather than describing generic steps.

MICROSOFT EXCEL DATA ANALYSIS TAB SERIES

One variable data table in Excel allows testing a series of values for a single input cell and shows how those values influence the result of a related formula.

MICROSOFT EXCEL DATA ANALYSIS TAB HOW TO

How to create a one variable data table in Excel If you are looking to learn about many possible ways to create, clear and format a regular Excel table, not data table, please check out this tutorial: How to make and use a table in Excel. A data table isn't the same thing as an Excel table, which is purposed for managing a group of related data.

Although limited to a maximum of two different input cells, a data table enables you to test as many variable values as you want. In Microsoft Excel, a data table is one of the What-If Analysis tools that allows you to try out different input values for formulas and see how changes in those values affect the formulas output.ĭata tables are especially useful when a formula depends on several values, and you'd like to experiment with different combinations of inputs and compare the results.Ĭurrently, there exist one variable data table and two variable data table. Excel data tables - 3 things you should know.

Data table to evaluate multiple formulas.

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.

Microsoft excel data analysis tab