Deleting Blank Sheet Rows When you import or download data, you frequently end up with a lot of blank rows that are interspersed amon...

In this example, we are going to walk through how to do a PMT function and then create an amortization schedule to make sure that the ...

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