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

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

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

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
image - 13 Data Entry Keyboard Shortcuts_Featured Image

13 Keyboard Shortcuts for Data Entry

13 Keyboard Shortcuts for Data Entry in Excel   The key element in entering data into Excel is completing the data entry by either clicking from one cell to another cell with your mouse or by using one of the keyboard shortcuts listed below to move to another cell.   Data entry into a spreadsheet is a very manual process and is still predominantly carried out using a keyboard. It […]

Do you need to Merge that? 5

Do you need to Merge that?   There are a number of “basic errors users make in Excel” that results in their spreadsheet life being that much more challenging when it doesn’t necessarily need too. One of these, which we are discussing today, is the use (or unnecessary use) of merged cells in an Excel spreadsheet.   Why Merge Cells?   Merging cells in a spreadsheet is a process that […]

image - Merge Cells Featured Image
image - D.A.R.E. Methodology Featured Image

D.A.R.E to be different 4

D.A.R.E. to be different!   A common misconception when it comes to learning about Excel and how to use it is that it is all about how do I use and implement all these functions and their capabilities. This misconception is further compounded by the fact that most Excel training just simply teaches you new functions and capabilities and does not dive into the VERY important stages that you need to […]

Hide Gridlines in Excel 4

Hide Gridlines in Excel Knowing how to hide gridlines in Excel is a common task that makes your spreadsheets clean, presentable and have a more professional look and feel.   What are Gridlines? A spreadsheet contains cells and gridlines represent the borders of these cells. They are the faint lines on your spreadsheet that help you to distinguish a cell’s boundary. By default, gridlines are displayed in your spreadsheets using a […]

image - hide gridlines featured image