I really do not like the way when you create a Pivot Table and add multiple fields to the Row or Column Label areas, subtotals are shown at the the top for outer fields.  This just does not sit well...

A really common task used frequently in Excel is to compare two lists to highlight items that appear in one list but are not in the other.  Here is a great way to combine two great Excel features to...

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

This is one of my favorite Excel tips..... Ever get a data download and one or more of your columns of data is downloaded or exported a text?.  All you need to do to quickly convert the column of...

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

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