TKC Academy offers the best MS Excel Training. If you have a better understanding of Advanced Excel features such as complex functions and analytical tools, you will have a better chance of being considered for a new position. For comparing data, the Vlookup function is the most commonly used. Taking a large raw set of data and reducing it to a more manageable list so that Pivot Tables can be created and data can be further analyzed. Consider Vlookup to be an enhanced copy-and-paste tool. After locating an invoice number in a list, return the outstanding amount. The V in Vlookup stands for Vertical, indicating that the lookup value is in the master list and is descending in one column. Hlookup is required when the lookup value data is contained in a single row. Horizontal is represented by the letter H. Vlookups are structured as follows: = Vlookup(lookup value, table, column No, True/False). In a Hlookup, the only thing that changes is the transition from a column to a row. If this doesn't work, you should learn Advanced Excel, which will teach you about the Index and Match functions.
|Tags:||#MS-EXCEL COURSE IN JANAKPURI, #MS-EXCEL COURSE IN PALAM, #MS-EXCEL COURSE IN RAMESH NAGAR, #MS-EXCEL COURSE IN UDYOG VIHAR|