VLOOKUP Function

 VLOOKUP stands for “Vertical Lookup”.

It can be used anytime that you have a list of data with the key field in the left-most column.

VLOOKUP needs four parameters.

Ist Parameter :  The cell value which needs to be SEARCHED.

2nd Parameter : The RANGE  with your lookup table. Highlight the range. Be sure to use F4 to make the range be absolute. (An absolute reference has a dollar sign before both the column number and row number. When the formula is copied, the reference will continue to point towards I3:J351.

3rd Parameter : In which column the Target Value to be found.
 In the Range of Lookup Table, if the column is 3, then you got to give as  3  for this parameter.

4th Parameter :  if a “close” match is OK.   then give  True.  If it is not, enter False.

Example :  http://www.mrexcel.com/tip096.shtml


Eg:  =VLOOKUP(Z7,AC6:AD14,2,FALSE)

In the above example

Z7 -- Cell no: consists of the data needs to be searched.
AC6:AD14 --- Range of the lookup table in which the output value shall be available.
2-- As we need the second column data in the lookup table  we have given 2.
FALSE -- we don't want close match. We need Exact Match. So, False is given.

Making Constant Value for a particular Cell

A1 cell Value = 60000
B1 cell Value =  1
B2 cell Value  = 2

C1 cell value = A1*B1


In order to make a cell value as CONSTANT you got use $ as below.

For a cell named A1,
$A$1 should be used.

For C1 cell value = A1*B1

C1=  $A$1*B1.

SHORTCUTS in EXCEL

Ctrl + Shift + L

Apply filter on selected column headings.

Ctrl+h

Display the Find and Replace dialog box (with Replace selected).

Shift+F4

Repeat last find.

Ctrl+g (or f5)

Display the 'Go To' dialog box.

Ctrl+z	Undo last action (multiple levels).
Ctrl+y	Redo last action (multiple levels).

Ctrl+Alt+v

If data exists in clipboard: Display the Paste Special dialog box.

Shift+Space	Select the entire row.
Ctrl+Space	Select the entire column.

F2	Edit the active cell with cursor at end of the line.

Ctrl+Delete	Delete text to the end of the line.
Ctrl+; (semicolon)	Insert current date.
Ctrl+Shift+: (colon)	Insert current time.

Shift+F2	Insert / Edit a cell comment.
Shift+f10, then m	Delete comment.

For More :
http://www.shortcutworld.com/en/win/Excel_2010.html

COPYING THE TEXT CONTENT OF PPT TO M.S.WORD.

Open the Power Point u want to copy the text. Do the following :
FILE------> SEND TO ---->MSWORD--->OUTLINE ONLY