Excel Tutorial

Excel Data Menu

A click on the "Data" tab in the Menubar or pressing "Alt + D" keys will open the Data menu. By default Excel opens the menu with commonly used commands only. (All commands available under the menu can be viewed by a click on the double downward arrow circular tab at the bottom of the menu.) A small triangle against a command name indicates a sub-menu for the command. The commands listed under File Menu can be executed or the sub-menu can be opened by a click on its icon / tab or by pressing key for the underlined letter after opening the menu. The commands listed under Data menu are :

Sort	Please Click Here to know about Sorting Data.
Filter	Please Click Here to know about Data Filter.
Form	This command enables to convert a range of data as a form with top row as header. You can display a data form that lets you enter new data, find rows based on cell contents, update the data, and delete rows from the range or list.
Subtotals	This command enable to incorporate Sub-total and Grand Total in a list.
Validation	This command enables to specify validation of data to be entered in a Cell viz. Whole Number, Decimal, Text, Number, Date, Time etc. with Maximum and Minimum values. You can also add "Input Message" to be displayed when the cell is selected and also an "Error Message" to be displayed when the data entered fails validation.

Table	Data tables are part of a suite of commands sometimes called what-if analysis tools. A data table is a range of cells that shows how changing certain values in your formulas affects the results of the formulas. Data tables provide a shortcut for calculating multiple versions in one operation and a way to view and compare the results of all of the different variations together on your worksheet. Please use Excel Help to learn more about Data Consolidation.
Text to Columns	This command enables to bifurcate text entered in rows into columns.
Consolidate	Consolidating data combines the values from several ranges of data. For example, if you have a worksheet of expense figures for each of your regional offices, you might use a consolidation to roll these figures into a corporate expense worksheet. Please use Excel Help to learn more about Data Consolidation.
Group and Outline	Group and Outline enables to group or un-group rows containing details data from rows containing totals for such rows. The Outline enables to outline the range containing details data and summary data. The symbols '1','2','3','+','-' enable to show / hide details rows and / or the range. For more about this command, please use Excel help.
Pivot Table and Pivot Chart	Please Click Here to know about Pivot Tables.
Import External Data	This command enable to import data from an existing or New data source. For more about this command, please use Excel help.
List	The command enables you to create lists for data fill. To create a List: Enter data in a range for which you want to create a list. Highlight the range of data that you want make into a list. On the Data menu, point to List, and then click Create List. If the selected data has headers, select the My list has headers check box and click OK.
XML	This command enables to use, import, export, validate XML (Extended markup Language) data in Excel. For more about this command, please use Excel help.
Refresh Data	This command enables to refresh imported and other data in the worksheet. The data in a worksbook is automatically refreshed, when it is opened.

Sitemap Privacy Toolbar Contact