Rank.EQ What do you do if you need to determine the order of your golf score or perhaps sales volume? The easiest way obviously is to sort y...

Extracting different parts of a date This is just a quick tip that you might find useful. A lot of times, you have a column of dates and if...

 Flipping Your Data How often have you typed your data in and then wished that it was presented differently?  The good news is that i...

It really used to annoy me that Excel did not highlight unlocked cells the way Lotus did. Lotus would automatically shade unlocked cells a n...

Everyone has their favorite way to copy . I have lost count on the how many ways there are to copy in Excel - but here is one that many of y...