Beat Excel! Get to next level in Excel!

For Each Loop (Excel VBA)

For Each loop is for looping through each element in a collection. It is especially useful when you don’t know how many elements there is...

Save As Multipage PDF File

Would you like your reports to look like e-magazines with multiple pages? Here is how to do it. All you need to know is how...

Copy Chart Formatting

  Did you know that you can format several of your charts in a workbook at once? Here is how to copy chart formatting.

Setup Live Table Headers With Date Functions

Are you tired of updating your table headers everytime you update your reports? You can setup live table headers so that they can update themselves....

Cool Gauge Chart Visuliations

Here are some very cool gauge chart visuliations for your reports and dashboards. I’ve come across these on some pictures of dashboards while browsing some...

Comparison Chart

Here is a combination chart with a trick. It is very compact and it shows comparison between two series very clearly. It is especially useful...