Practical Advice


How to Unprotect my Excel VBA Project without the password

It is not unusual for people other than the creators/developers of Excel spreadsheets to take ownership of these tools, especially in a business environment. These transitions of ownership usually go smooth. But there are definitely times that can cause some real headaches for the new owners. We receive emails similar to the following all the time: “Hi, I am working for [XYZ] company and one of our staff have recently […]


How to Remove an Excel Spreadsheet Password in 6 Easy Steps 26

This post we show how to remove an Excel spreadsheet password in 6 easy to follow steps. It is an update to an earlier article where we discussed how you may be able to unprotect an Excel spreadsheet if you have forgotten the password used to protect it. Click here to read that article. Unfortunately, there is no way that we can view or recover what your lost password is. […]


What size Solar Panels do I need?

What size solar panels do I need?    So how many and what size solar panels do you need to meet your camping power usage requirements? A simple enough question to ask, but unfortunately not always a simple question to answer. Fortunately, we have developed a simple to use Excel spreadsheet, that allows you to input information about the equipment you use and your power usage and it will let […]


What are the 56 ColorIndex colors in Excel

Excels 56 ColorIndex Colors   Color Palette Excel’s Color Palette has an index of 56 colors which can be used throughout your spreadsheet. Each of these colors in the palette is associated with a unique value in the ColorIndex. For reasons unknown, aside from the index value, Excel also recognizes the names for Colors 1 through 8 (Black, White, Red, Green, Blue, Yellow, Magenta, and Cyan).   interior ColorIndex HTML […]


Don’t Wait – The Time will Never be Right

Don’t Wait – The Time will Never be Right.   A great quote from Napolean Hill… With a little tweak by us at the end…   If you are waiting for that perfect moment, it will never happen and you’ll end up spending all your time waiting…   So take action. Don’t put it off any longer. Jump on in and start learning Excel today!!   Click here to start […]

image-Don't Wait. The Time will Never be Right - Featured Image

image - Formula Basics for SME's

Excel formula basics every Small to Medium Business Owner should know 4

Excel formula basics every small to medium business owner should know.   One of the most powerful features of Excel is its ability to allow you, the user, to specify relationships between the information you have stored in your worksheets. Having the ability to be able to specify these relationships i.e. using formulas between your information, can significantly enhance and improve the usefulness of your spreadsheets.   Formulas allow you […]


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