Trick

How to Unprotect an Excel spreadsheet if you have lost your password 59

This entry was posted in How To Practical Advice Trick by

I recently had the circumstance where a client sent me a copy of a spreadsheet that was password protected, however the client no longer had the password to unlock the content. They were wondering if there was anything we could do… Unfortunately, there is no quick and simple way for your to view or recover a lost password in Excel. So what do you do when you need to unprotect […]

image - Access Denied
image-Custom Formatting Featured Image

Cracking the Mystery of Custom Number Formats in Excel

This entry was posted in How To Tip Trick by

Cracking the Mystery of Custom Number Formats in Excel.   Excel has many built-in formatting options that you can apply to your information. These range from Number, Currency, Accounting, Date, Time, Percentage, etc to name just a few. But what do you do if you cannot find the exact format you want to apply to your information? Why you create your own custom format that’s what.   To create your own […]

Declutter your Spreadsheets by Hiding Zero Values

This entry was posted in How To Practical Advice Tip Trick by

Declutter your Spreadsheets by Hiding Zero Values. Are your spreadsheets filled with unnecessary zero’s, cluttering your information and making it hard to identify significant results?   Undertaking data analysis in Excel quite often results in your formulas returning zero’s simply because they point to cells that do not contain any data. I know I come across this ALL the time as I attempt to make my spreadsheets as flexible as […]

image - Featured Image Hide Zero Values