How to restore the old “Save As” button in Excel (or Word)
Remember the good old days when the top left menu icons in Excel and Word were nice big Save and Save As and New buttons? Weren't they were useful buttons?…
Compare two lists; or how to find duplicates in Excel
Comparing two lists, or comparing items within a single list is one of the most common business tasks done with a spreadsheet. You might have a list of names or…
How to set up a Paste Values Shortcut in your Excel personal workbook
If you use Excel every day, you will usually end up becoming familiar with the shortcut keys such as CTRL-C (Copy) and CTRL-V (Paste). Another function very frequently used by…
How to remove duplicates in Excel (or any spreadsheet)
A common problem when working with lists is the occurrence of duplicates within the list. In business its commonly required to “clean up” lists, so that there’s exactly one of…
How to Round Off to the Nearest 5 Cents in Excel
Cash rounding is in use in many countries where retail prices are rounded off to the nearest 5 cents, usually because the 1c and 2c coins are no longer in…