● Pivot Table is an interactive way to quickly summarize large amounts of data. It is used to summarize, sort, reorganize, and group. It allows us to extract the significance from a large, detailed data set.
● VLOOKUP: It is a function that makes Excel search for a certain value in a column, to return a value from a different column in the same row.
● HLOOKUP: Stands for Horizontal Lookup. It is a function that makes Excel search for a certain value in a row, to return a value from a different row in the same column.
● SUMIF: SUMIF is the function used to sum the values according to a single criterion. Using this function, you can find the sum of numbers applying a condition within a range. Similar to the name, this will sum if the criteria given is satisfied. This function is used to find the sum of particular numbers within a large data set.
● INDEX MATCH: The INDEX MATCH formula is the combination of two functions in Excel: INDEX and MATCH.
=INDEX() returns the value of a cell in a table based on the column and row number.
=MATCH() returns the position of a cell in a row or column.
Combined, the two formulas can look up and return the value of a cell in a table based on vertical and horizontal criteria.
