Excel 2010

Jan 29 2012

How to make hyperlink in the worksheet:

  1. Open the excel sheet, 2. Right click to any of the cell and click to the hyperlink option, or simply do Ctrl +k Insert Hyperlink dialogue box will open. 3. Give any text to display. For e.g. Click here 4. Type the cell reference : I.e. if you want to hyperlink on the [...]

By Palavi Joshi • All blogs, Excel, Microsoft • 0 • Tags: ,

Jan 27 2012

Boost your Excel skills with Transpose

Transpose :- A horizontal range of cells is returned if a vertical range is entered as a parameter. Or a vertical range of cells is returned if a horizontal range of cells is entered as a parameter. ex1 : Vertical to horizontal Copy the cells from B Go to different cell, right click and select [...]

By Abhishek Joshi • All blogs, Excel, Microsoft • 1 • Tags: , , ,

Jan 27 2012

Boost your Excel skills with VLOOKUP

From  last 5 years I’m getting help from VLOOKUP, though to share with you some examples with you Ex 1 :- Find employee from column A in Column D Write “=VLOOKUP()” in cell B1, it will open “function argument” window Select “Lookup_Value” as cell “A2”, “Table_Array” as Column D and as we have selected only [...]

By Abhishek Joshi • All blogs, Excel, Microsoft • 0 • Tags: , , , , ,