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

It is really easy to move a whole Excel data table to a new location on the same worksheet or even a new location on a different worksheet in the same workbook or an entirely different workbook.  I...

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

This is a small tip but a good one......Yes I called them dancing ants in the title of this tip but I am actually talking about the marquee that is around copied cells.  If you want to quickly get...