For example, you can use a one-variable data table to see how different interest rates affect a monthly mortgage payment by using the PMT function. You enter the variable values in one column or row, and the outcomes are displayed in an adjacent column or row.

To make managing and analyzing a group of related data easier, you can turn a range of cells into an Excel table (previously known as an Excel list). Note: Excel tables should not be confused with the data tables that are part of a suite of what-if analysis commands.

This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result. Create the Sample Worksheet. This article uses a sample worksheet to illustrate Excel built-in functions.

Use a two-variable data table to see how different values of two variables in one formula will change the results of that formula. For example, you can use a two-variable data table to see how different combinations of interest rates and loan terms will affect a monthly mortgage payment.

Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.

The GETPIVOTDATA function returns visible data from a PivotTable. In this example, =GETPIVOTDATA("Sales",A3) returns the total sales amount from a PivotTable: Syntax

In these tutorials you learn how to import and explore data in Excel, build and refine a data model using Power Pivot, and create interactive reports with Power View that you can publish, protect, and share.

How to use the FILTER function in Excel to filter a range of data based on criteria you define.

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

Use AutoFilter or built-in comparison operators like "greater than" and "top 10" in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.