Anything Under the Sun

1.) Entering Texts, Dates, and Numbers

--> Text
Any combination of numbers, spaces, and non-numeric characters.
By default, it is left aligned in the cell.

--> Date
By default, it is right aligned in the cell
Press Ctrl + ; to enter the current date

--> Time
By default, it is right aligned in the cell
Press Ctrl + Shift + ; to enter the current time

--> Numbers
By default, it is right aligned in the cell

2.) Using AutoComplete and Pick list

-->To Use AutoComplete
Excel automatically completes the text when you type the first few characters in a cell that match an existing entry in that column.

-->To Use Pick List
Right click the cell wherein you want to enter a label.
Select Pick from List from the shortcut menu, ad then select the entry from a list.

3.) Inserting, Deleting, and Moving Cells

--> To Insert Selected Cells
Select the cell or range.
In the Insert menu, click Cells.
Choose from the Insert Cell Options.
Click OK.

--> To Delete Selected Cells
Select the cell or range.
In the Edit Menu, click Delete.
Choose one of the Delete Options.
Click OK.

--> To Move Cells through Drag and Drop
Select the cell or range.
Drag the selection by its outside border to the upper left cell of the area where you want to move the cell or range into.
Release the Mouse Button.

4.) Using Find and Replace

--> To Find Information
In the Edit Menu, click Find.
Enter the texts or numbers that you want to search for in the Find What Box.
Click the Find Next Button. You can click the Find Next Button if there is more than one occurrence. Do so until you find the text that you’re looking for.

--> To Replace Information
In the Edit Menu, click Replace.
Enter the text that you want to search for in the Find What Box and the text that you want to replace it with in the Replace With Box.
Click Find Next Button to find the text and the Replace Button to replace the text.

5.) Sorting a List

--> To Sort a List by One Field
Select the cells in the column to which you will apply the command. Click either the Sort Ascending Button or Sort Descending Button on the Standard Toolbar.

--> To Sort a List by More than One Field
Activate the cells within the list. Select Data Menu, and then click Sort.
Select the first field that you want to sort from the drop-down list, and the specify Ascending or Descending order.
Select the second and the third fields that you want to sort (if desired).

6.) Filtering a List

--> To Use the AutoFilter
Move the cell pointer anywhere within the list.
On the Data Menu, select Filter, and then AutoFilter.
Select the filter criteria from the drop-down arrows by the field names of the header row.

--> To Remove an AutoFilter
In Data Menu, select Filter, and then AutoFilter.

--> To Create a Custom AutoFilter
Move the cell pointer anywhere in the list.
In Data Menu, select Filter, and then AutoFilter.
Click one of the drop-down arrow options in the field names of the header row. Select Custom from the list.
Specify your filter criteria in the Custom AutoFilter Dialog Box.

7.) Working With Series
A series is a sequence of cells that form a logical progression.

--> To Use the Fill Handle
Enter the first item of the series in the given cell.
Move the Mouse Pointer to the bottom right corner of the cell to the Fill Handle (the pointer changes to the black plus sign).
Drag the Fill Handle.
Release the Mouse Button to complete the series.

--> To Create a Custom Series
In the Tools Menu, click Option.
Click the Custom List Tab, and then select New List.
Click the Add Button to enter items in the list.
Type the entries into the List Entries Box. Press Enter after each entry.
Click the Add Button again.

--> To Use the Series Dialog Box
In the given cell, enter the first item of the series.
Highlight the range of cells that will be included in the series.
In the Edit Menu, click Fill, and then select Series.
In the Series Dialog Box, click the Series in Option.
Choose the Type option.
Type the value for Step Value and Stop Value.
Click OK to complete the series.