Be familiar with Excel

Following are some tips

SPLIT WINDOWS AND FREEZE PANES

In excel you would need to use splitting function because Splitting a window allows you to work on multiple parts of a large spreadsheet simultaneously and Freezing the pane allows you to always keep one part of the spreadsheet (e.g., column or row labels) visible.

To use this function Drag the split horizontal and split vertical icons to the desires positionsClick on the freeze pane icon from the tool bar to freeze the panes

HIDE AND UNHIDE COMMAND

Hide and unhide function in excel Allows you hide and unhide particular rows or columnsSimplifies working with the spreadsheetPrevent certain information from being seen
To use hide and unhide Select the row(s) or column(s) to be hidden/unhiddenSelect Format : Row : Hide/Unhide or Format : Column : Hide/Unhide
MOVING AROUND A SPREADSHEET WITH CTRL, SHIFT, AND ARROW KEYS

It saves your lots of timeMove the first or last cell of a contiguous data block without scrolling

To use scrollfree movement use following keys

Ctrl-Arrow : Move to the first/last data cell in the arrow direction

Ctrl-Shift-Arrow : Selects the cells between the current cell and the first/last data cell

NAME CELLS/RANGES

Why to use :
Allows specific cells or cell ranges to be referred to by name
Allows you to write equations such as = Quantity*Cost instead of =$B$12*$C$4

How to Use:

Select the cell or cell rangeSelect Insert : Name : Define from the menu bar

SORT COMMAND

Use :

Correctly sorting a series of rows or columns without disassociating the data is critical to many modeling efforts

how to use:

To sort by single category, just click into column, NEVER highlight column (would destroy table integrity)To use multiple criteria, click any cell of data table, select Data…Sort Data table will be selected