Today with all the online presentations be it YouTube, Webinars or just an in-house presentation, visual impact has become a lot more impor...

How to password protect and encrypt an Excel workbook How many passwords do you have? The answer is probably too many.  Unfortun...

If you are setting up a spreadsheet for someone else to enter data this is a neat trick. You can use the Data Validation and the CountIF f...

Want to Learn VBA? I've had a couple of people asking about VBA lately and wanted to tell you about a site that contacted me. They are...

Quick Tip for Refreshing Pivot Tables Alt+F5 will refresh all the Pivot Tables on the sheet. CTRL +ALT+F5 will refresh all Pivot Tables ...