Happy Formula Friday!.  This Friday we are a bit stuck in the middle, yes you guessed it - its MEDIAN time. As you probably know, the MEAN is a useful way to summarise a group of numbers.  But...

Hi guys, this is a new type of post for me Formula Friday.  Every Friday I will blog on a formula or function in Excel.  I'm looking forward to this new posting schedule.  Today's post will be the...

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

Ever need to find out which value in your data set occurs most frequently? Yes I have as well more often than I thought I wold when I learned this Excel tip.  Well here is a really easy way to do...