Tagged: tutorial for excel

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...

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

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...