Vlookup Function
Vlookup function is one of the most important functions in excel for me. It helps you fetch a value from a list of values looking...
Tagged: tutorial for excel
Excel Slicers
With Excel 2010, we have a very cool tool named Excel Slicers for filtering pivot tables and pivot charts dynamically with one click. Your reports...
Pivot Chart
Pivot chart is a powerful side product of renowned pivot table. It has all the filters that are present on source pivot table. That...
Introduction to Pivot Table
Pivot table is wihtout a doubt one of the most loved features in excel. It makes data analysing as easy as childs play. And pivot...
Excel Table
Excel Table is a must know feature of excel! It is like a bunch of useful features packed into one for your convenience.
Conditional Formatting
Have you ever tried to change formatting of a cell or a range of cells based on a condition? If so, conditional formatting is the...
