Using a One or Two Input Data Table

You can use Excel data tables to test how your formula results will vary when the data that the formula operates on changes. You do this by specifying a series of hypothetical values that Excel will use to evaluate the formulas with. 

What is a Scenario?

In business it can often be beneficial to explore multiple scenarios for a given situation. This allows you to see what combination of factors gives the best results; in other words, test various scenarios. With Excel 2010, you can easily explore multiple scenarios based on the same data.

Grouping Data Manually

Automatic outlining may not be adequate for worksheets with non-numerical values or with no distinct totals (from formulas and functions).

Automatic Outlining

Excel's automatic outlining feature makes outlining a worksheet fairly straightforward. Automatic outlining works best with numerical data organized into groups and sub groups by formulas or functions. The following worksheet, for example, contains monthly financial data for a business, organized into quarterly totals using formulas and the SUM function: