Thursday, December 13, 2012

Data

Data:


Sort: Sort command rearranges a range of worksheet data alphabetically or numeric in order the sort command is suited for rearranging the rows of a list or database, you can also rearrange columns of data. You can define as three keys of each sort operation in Ascending or Descending Order.

Filter: Filter allow you to work with selected rows of information in list, including a list that you have organized as a database. Excel gives you two effective ways to filter a list or database. The simpler of the two techniques is known as AutoFilter. When you select this feature, Excel provides drop-down lists at the top of every columns in your database.

Forms: Displays the column labels that correspond to each column in your list. In the box to right of the column labels, you can enter new records at the end of the list, edit existing records or find records in your list based on criteria you specify. If you click the restore button then restores edited fields in the displayed record removing your changes.


Subtotal: Calculate a subtotal for the columns you select and inserts subtotal rows in the current list. Microsoft Excel inserts a subtotal row at each change in the column you select and a Grand Total row at the bottom of the list.

At each change in: Select a label from the at each change in box to specify the column the items or groups by which you want to subtotal values in other columns.

Use Function: You can also select a function to use for the subtotal calculation; Sum is the most common choice, but other function are also available, such as Count, Average, Max, Min, Product, Count Num etc.

Add subtotal to: Select one or more check boxes under add subtotal to specify the columns that contain value you want to subtotal.

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 limits on the valid entries.

Text to columns: Separates text in one cell on a worksheet into columns by using the convert text to columns wizard.

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.

Consolidate: This Command is used to merge two or more files (Table) with functions.

Pivot Table: A Pivot Table is dynamic, customizable tool designed to help you rearrange, summarize and explore information from a database or list. The pivot table wizard provides a simple four-step graphical approach. First Choose the Microsoft Excel list or database, External Data source, Multiple Consolidate Range, Another Pivot Table.
Second select the pivot table in new sheet or select the cell on the worksheet, or type a cell reference in the existing worksheet box to specify the upper-left cell of the range on the worksheet where you want the pivot table to be placed.