Excel is a complex tool that has a lot of features and provides a lot of benefits for businesses. Some features are easy to learn, however, others can be very complex and difficult to master. There are many people that claim to be an expert using Excel, but quite often they fall short and may not have the necessary experience or skills you really need to undertake your project. So […]
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 easily convert Decimal Degrees to Degrees Minutes Seconds [in Excel]. Came across this Microsoft Excel formula the other day which easily allows you to convert Decimal Degrees to Degrees Minutes Seconds within seconds. It is very easy to use – simply copy and paste the formula into Excel and change the [Lat Cell] or [Long Cell] text within the formulas to point to the cells with the Decimal […]
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? 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 […]
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 […]
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 […]
