Category: Advanced

Goal Seek

Are  you curious about how many years do you need to work until retirement? Or are you trying to figure how many workers do you...

Incell Chart

  Do you know that there exist another way of having micro charts in one cell. This is called an incell chart. It is neat,...

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