The Data Menu

DataSort...

Sort data in selected cells. See the section Sorting Data for more details.

DataText to Columns...

This option attempts to interpret text in the selected cell(s) as CSV data, placing each item into a different cell in the row.

DataNamed Areas... (Ctrl+Shift+G)

Open the Named Areas dialog to select, add, edit and remove named areas. See the section Named Cells and Areas for further details.

DataConsolidate...

Consolidate data. See the section Consolidating Data for more details.

DataSubtotals...

Create different kinds of subtotals to a database.

DataValidity...

Set or modify the error checking criteria and error alert message for selected cell(s). See Validity Checking for more details.

DataGoal Seek...

Open the Goal Seek dialog box. See Goal Seeking for details.

DataPivot...

Open the Pivot Table configuration dialog. See Pivot Table for details.