Yes indeed Excellers it is Pivot Table week at how to excel at excel.com For some they are something they cannot live without in Excel world, for others they make them run screaming away at the very...

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

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

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

If you frequently use Microsoft Excel, you might have come across the need to merge cells in your worksheet to make it more presentable or easier to read. However, sometimes, these merged cells can...