If you find that users are consistently entering incorrect data into worksheets then using Data Validation to prevent users entering invalid data and also displaying a message to prevent them is the...

Want to create your own style Excel work book to re use over and over again? It is easy to create your own default template in Excel to fit in with your corporate style or your own personal...

Here is another fab Excel tip. Excel is kind of clever as if you didn't already know.  Excel will automatically fit your data to your cells by shrinking it.  The data in the cell is fitted...

If you have a large worksheet with a lot of data then finding exactly what you are looking for can be problematic. The Excel Find And Replace dialog box is the most useful tool for this...

We are all in a hurry, most of the time, so I thought I would share one of my all time favorite Excel keyboard shorcuts.   How to Close An Excel Workbook If you want to close  a selected...

Whilst using Excel there will be a good number of scenarios where you want to find the number of unique values you have in a range of cells.  this could be Customer Names, Invoice Numbers, Order...