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
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.
