Category: Advanced

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

Interactive Chart Example – 2

This chart is a very cool looking chart with very nice spinning effect. There is no macro used for this interactive chart, only formulas and...