This tip is one my most favorite time savers when using Pivot Tables- the ability to create many reports with just a few mouse clicks. The scenario for this example is the national sales manager...

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

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