PIVOT- IN MS excel Pivot table/chart is used for summarizing the data. Go to the tool bar select the insert tab and there clock on the pivot table option. Pivot table will give summary of the whole sheet, by placing the row and column values we can make analysis very easily. Lookups are used for targeting any specific from whole sheet. Vlookup- when we want to select specific value from a column then we use this function. Hlooup- when we want to specify value from a row then we use this formula.