Understanding Pivot Tables in Excel
A pivot table is an analysis tool used when a data table is too large. For example, if you have an HR data table containing employee data, you can use it to analyze the date-wise joining of employees and their CTC. Using a pivot table, you can quickly arrange the data as needed in less than a minute.
Using VLOOKUP and HLOOKUP Functions
VLOOKUP and HLOOKUP are functions defined in Excel that help find records from one table to another horizontally and vertically. However, certain conditions need to be met for these functions to work correctly. Refer to Excel's help section for understanding these conditions. The VLOOKUP function syntax is as follows: @VLOOKUP(reference of data to find, reference table where the data can be found, result column number, else zero).