Excel takes a snapshot of your data set when you create a Pivot Table report and stores it in a pivot cache.  This is just an area where your data source is duplicated for easy access, this is...

This tip is really useful for Excel dashboards or anywhere that space is of a premium on a worksheet or, where your data set is just too large to comfortably display. Let's look at using a scroll...

If you have extra data that you need to add into your charts, then the usual way in Excel 2007 onwards of adding data is to drag the blue box line with the mouse but this will work only if your chart...

Before I found out about this little tip, the multiple stacked report filters in my Pivot Tables REALLY annoyed me. So, here is how to avoid all of those stacked up messy filters. Yuk. I have used...

When Excel is installed the default chart is a clustered column chart, so if you hit F11 for a quick chart then that is the type of chart that is created. If you do not often use a clustered...

Dashboard skills are in great demand by employers, if you can build great dashboards; it is a valuable skill to have. Even better if you can build them in one of the most widely used pieces of...