Ctrl+N        Open New Excel Workbook
  Ctrl+S        Save opened Workbook
  Ctrl+O        Open dialog box where you can select workbook you want to open
  Ctrl+P        Print the existing excel sheet.
  Ctrl+F        to Find
  Ctrl+H        to Replace
  Ctrl+A        to select Entire sheet.
  Ctrl+B        to bold the selection
  Ctrl+C        to Copy
  Ctrl+V        to Paste
  Ctrl+D        to view the content of upper cell into lower cell. For example you had typed 
                  hello in A1 move to A2 and press Ctrl+D it will show hello in A2.
  Ctrl+G        go to particular cell depending upon cell address.
  Ctrl+I        to make selection Italic
  Ctrl+K        to insert hyperlink into selection.
  Ctrl+L        to create List (Specify the address of data that you want to include into list.)
  Ctrl+U        to underline the text.
  Ctrl+W        to close the workbook.
  Ctrl+X        to cut and copy
  Ctrl+Z        to undo last action
  Ctrl+F1       task pane
  Ctrl+1        Format Dialog box
  Ctrl+F3       to define name for particular address.
  Ctrl+F5       to change the size of excel workbook within excel window.
  Ctrl+F9       to minimize the excel workbook while keeping excel window maximize.
  Shift+F2      to add comment 
  Shift+F3      to insert Function from Insert Function dialog box.
  F7                Spell Checking
  F1                Help 
  Shift+Ctrl+F  to select the font style text box, and use arrow to select font.
  Shift+Ctrl+P  to select the font size box, and use arrow to select font size.

Selection Tricks

To select whole column, Click on the column name. For example you want to select

a column for the entire sheet. Simply click on A.

To select whole row, click on the row number that you want to select.

Shift+Home Select all the cells in particular row from the point of selection up
to row number towards left side.

Shift+Spacebar Selects the entire row.
Ctrl+Spacebar Selects the entire column.

Shift+Ctrl+Down arrow to select the entire used cell in particular column downwords.
Shift+Ctrl+Up arrow to select the entire used cells in particular column upwards.
Shift+Ctrl+RightArrow to select the entire used cell in particular row towards right side.
Shift+Ctrl+Left Arrow to select the entire used cell in particular row towards left side.

Usefull Data Cleansing Function:

=VLOOKUP(A1,Sheet2!$A$1:$A$3,1,0)
=IF(D1=A1,1,0)
=IF(ISNUMBER(E1),1,0)
=SUBSTITUTE(G1," ","")
=Code(Value Address) Returns the ANSI code Window system.
=Char(Value Address) Return the Character Corresponding to ANSI Number.
=FIND(Text to Find, Where to find)
=LEFT(A1,FIND(" ",G2)-1) Extract First Name
=RIGHT(G2,LEN(G2)-FIND(" ",G2)) Extract Right Name
=LEFT(B1,1)
=RIGHT(B1,1)
=MID(ValueAddress, Starting Point, Number of Character from Starting Point)
=ISTEXT(B2)
=ISBLANK(value)
=ISERR(value) Refers to All Errors Expect #N/A
=ISERROR(value) Refers to All Errors
=ISLOGICAL(value)
=ISNA(value) Refers to #N/A
=ISNONTEXT(value)
=ISNUMBER(value)
=ISREF(value)
=TYPE(value)
=ISEVEN(value)
=Lower("a2")
=Upper("a2")
=Proper("a2")
=Concatenate()

Financial Function:

FV

FV function is used to calculate the future value of the investment. It takes three arguments first is time period (usually in months), second is payment and third is interest rate. payment and interest rate is fixed for all the periods.

Basic Function:

Sum()

Sum function is used to sum all the values in the specified range.
Enter data into Excel sheet.
Click into cell where you want to display the sum.
Type following formula
Sum(val1, val2, valn) or Sum(val1address, val2address, valnaddress)
Or Sum(starting address : end address)
Example is given below which helps to understand the concept.

Min()

Min function is used to find minimum value in the specified range.
Enter data into Excel sheet.
Click into cell where you want to display minimum item.
Type following formula
Min(val1, val2, valn) or Min(val1address, val2address, valnaddress)
Or Min(starting address : end address)
Example is given below which helps to understand the concept.

Max()

Max function is used to find maximum value in the specified range.
Enter data into Excel sheet.
Click into cell where you want to display maximum item.
Type following formula
Max (val1, val2, valn) or Max(val1address, val2address, valnaddress)
Or Max(starting address : end address)
Example is given below which helps to understand the concept.

Count()

Count function is used to find total number of values in the specified range.
Enter data into Excel sheet.
Click into cell where you want to display total number of items.
Type following formula
Count(val1, val2, valn) or Count(val1address, val2address, valnaddress)
Or Countin(starting address : end address)
Example is given below which helps to understand the concept.

Avg()

Avg function is used to find the average of given values.
Enter data into Excel sheet.
Click into cell where you want to display the average.
Type following formula
Avg(val1, val2, valn) or Avg(val1address, val2address, valnaddress)
Or Avg(starting address : end address)
Example is given below which helps to understand the concept.

Move/Copy Sheet Difference
Before you use one of these options you need to understand the difference between move and
copy a worksheet.

When you Choose move option, worksheet will move to another workbook and will no longer exists
in the first workbook where it was before. If you choose copy sheet option then the selected worksheet
will exists in both workbooks (source and destination). To move or copy a sheet, use these steps.

1. Right click on sheet tab that you want to move or copy.
2. It will open a pop up menu as shown below.



3. Select move or copy option from that menu. Another menu will appear as shown below.


4. First select the destination workbook in the “to workbook” combo box. If there are two workbook
open at the same time it will show you name of the both books (and more if there are more then 2 workbooks
open at the same time), and add new workbook option. Select where you want to move or copy the worksheet.

5. Once you select the destination workbook, in the following box you can see all the sheets exists in
destination workbook. You can copy or move workbook before any worksheet (in the destination workbook) or you
can move or copy it to end of all sheets.

6. Then you need to decide whether you want to move or copy a sheet. If you want to create a copy simply
check the Create a Copy check box or leave it unchecked if you want to move a worksheet to destination workbook.
Create HypeLink
To create hyperlink follow these steps.

1. Enter the text, that you want to use as hyperlink.
2. Select the text and press ctrl+k or go to insert menu click on hyperlink.



3. This will open edit hyperlink dialog box as shown below.
4. In the address section write the URL address, click ok.


5. Move the mouse over the hypertext it will show message as shown in following figure.

Conditional Formating
Conditional formatting is very useful feature of Excel. It can be useful to find figures in huge
volume of data. Suppose you have 3000 records in excel sheet and you are interested in finding values
(for a particular column) that match the specified criteria. Criteria may be different every time
depending upon your needs. For example you criteria may be find those value which lies in particular range,
grater then specified value, less then specified value etc. If there is any such value exists in record we can
highlight using conditional formatting and in the end we can easily locate those records.

Suppose you are interested in finding those values in record set that whose value is grater then .40. For this you
can use following steps.

1. Select the Data range.
2. Click on format menu and select conditional formatting option. The following dialog will appear on your screen.

3. Select grater then option as shown below and enter 0.40 in next box.

4. Click on format button, format dialog will appear on your screen.

5. Select bold option and change colour to orange.
6. Click ok, you will get result like this. Now it is very easy to differentiate records those have value grater then .40.

Create Chart