Data Menu -Easy Excel

Data Menu

Sort

Arranges the information in selected rows or lists alphabetically, numerically, or by date.

AutoFilter

The quickest way to select only those items you want to display in a list.

Advanced Filter

Filters data in a list so that only the rows that meet a condition you specify by using a criteria range are displayed.

Form

Displays a data form in a dialog box. You can use the data form to see, change, add, delete, and find records in a list or database.

Subtotals

Calculates subtotal and grand total values for the labeled columns you select. Microsoft Excel automatically inserts and labels the total rows and outlines the list.

Validation

Defines what data is valid for individual cells or cell ranges; restricts the data entry to a particular type, such as whole numbers, decimal numbers, or text; and sets limits on the valid entries.

Table

Creates a data table based on input values and formulas you define. Data tables can be used to show the results of changing values in your formulas.

Convert Text to Table

Converts the selected text to a table.

Consolidate

Summarizes the data from one or more source areas and displays it in a table.

Group

Defines the selected rows or columns of detail data as a group in an outline, so you can summarize the data. If you have not created an outline, this command creates one for you

In a PivotTable or PivotChart report, this command groups items in a field to create a single item from multiple items; for example, you can group days, weeks, months, or other dates into quarters.

Ungroup

Removes selected rows or columns from a group on an outlined worksheet.

In a PivotTable or PivotChart report, this command separates each instance of a group into the items contained in the group; for example, it separates quarters into the original individual dates.

Auto Outline

Automatically outlines a selected range of cells or the entire worksheet, based on formulas and the direction of references.

Clear Outline

Removes the outline from the selected group of data. If the selection is not a specific group within the outline, the outline is removed from the worksheet.

Settings

Specifies the options used to outline and summarize data in a worksheet or a selected range of cells.

PivotTable and PivotChart Report

Starts the PivotTable and PivotChart Wizard, which guides you through creating or modifying a PivotTable or PivotChart report.