Category: Advanced

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.

Sparklines (incell chart)

Are you looking for ways to enhance your reports. If so, you can check sparklines. Having micro charts will make your charts look professional…

Self Filling Chart

Here is a very easy to do fancy self filling chart. Lets see how to do it…

Dynamic Chart Title

Are you updating your chart title manually all the time for certain changes in data. It is time that you set a dynamic chart title...