Quickie Excel Tips: Close A Workbook and Close Excel Using Shortcuts
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...
How To Count Unique Items In A Range Of Cells Using Advanced Filtering
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...
Extra Free Day For Everyone- What Will You Do With Yours? Learn More About Excel Dates?
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...