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

One of THE most useful features in Excel is the pivot table which is used to summarize, analyze, explore, tabulate and present your data.  Not just small amounts of data, but we can cope with huge...

I have included this tutorial as part of the Pivot Table Tutorials as I have found to fully understand and get the best out of this fantastic Excel function you need to know the core terminology,...

Some users love merging cells, some don't. I admit I am the latter, in fact I do not like them with a passion. Ok, they can be useful sometimes for example in a template or two, to make them look and...