Top 4 Tricks in Excel you should know

MS-Excel is a really powerful tool and most heavily used all over world by every professional and in all sectors from corporate to education. Today we will let you know the top 3 tricks in excel which will improve your performance in terms of time and quality. PIVOT table is one of Excel’s most powerful feature. Using PIVOT table you can create your own extract from a large detailed data set. For example we have the below table containing 5 columns as you can see.   Here comes the two-way pivot table that breaks down the amount by product and category as follows.   Click here to see the detailed step of creating different kinds of PIVOT table as per your need. 2. The VLOOKUP function is one of the most commonly used functions in Excel. VLOOKUP searches for a value in the first column of a table with information organized vertically. From the row with which the value matches, it retrieves a value from the specified column. = VLOOKUP (value, table, col_index, [range_lookup]) ...