सीधे मुख्य सामग्री पर जाएं

My Profile

Hi
My all friends

i am Govind Ram Bishnoi

I am Trainer For Advanced Excel in NIIT

If you more informsan click Below link

https://www.blogger.com/home





टिप्पणियाँ

इस ब्लॉग से लोकप्रिय पोस्ट

ROW Function

MS Excel:  How to use the ROW Function (WS) This Excel tutorial explains how to use the Excel  ROW function  with syntax and examples. Description The Microsoft Excel ROW function returns the row number of a cell reference. The ROW function is a built-in function in Excel that is categorized as a  Lookup/Reference Function . It can be used as a worksheet function (WS) in Excel. As a worksheet function, the ROW function can be entered as part of a formula in a cell of a worksheet. Syntax The syntax for the ROW function in Microsoft Excel is: ROW( [reference] ) Parameters or Arguments reference Optional. It is a reference to a cell or range of cells. Returns The ROW function returns a numeric value. Note If the reference parameter is omitted, it assumes that the  reference  is the cell address in which the ROW function has been entered in. For example, the ROW function used in the picture above returns 1 because the RO...

VLOOKUP Function

MS Excel:  How to use the VLOOKUP Function (WS) This Excel tutorial explains how to use the  VLOOKUP function  with syntax and examples. Description The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a  table  and returning the value in the same row in the  index_number position. The VLOOKUP function is a built-in function in Excel that is categorized as a  Lookup/Reference Function . It can be used as a worksheet function (WS) in Excel. As a worksheet function, the VLOOKUP function can be entered as part of a formula in a cell of a worksheet. The VLOOKUP function is actually quite easy to use once you understand how it works! If you want to follow along with this tutorial, download the example spreadsheet. Download Example Syntax The syntax for the VLOOKUP function in Microsoft Excel is: VLOOKUP( value, table, index_number, [approximate_match] ) Parameters or Arguments value T...