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 datewise joining of employees and their CTC. Using a pivot table, you can quickly arrange the data as needed in less than a minute.
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).