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

Every four years we get an extra day, how cool is that, so just what will you do with your extra day this February?. You could use it to learn more about date calculations in Excel?...Why...

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

This is one of my favorite EVER timesaving Excel Tips Need to quickly select all of the cells that contain data in your worksheet? This could be for formatting, or a a selection of data for a...

Gaps can be good, - sometimes - but not always on the Axis of your Excel chart. I think it looks like something is missing somehow or just downright untidy.  A bit like my example here...

This really was something that annoyed me until I found out how to fix it!  If you have large numbers on your Y axis it can take up waaaay too much space.the sales here may be good but the Y Axis...