If you need to share your train of thought or logic in your excel formulas or need a reminder to yourself of the formula purpose then you can add comments directly to the formula itself. After...
Category: Formulas
Ever needed to use a VLOOKUP but don't you know exactly how to spell what you are looking for, for example you may not remember how to spell a product name or the spelling of a Sales Person. Is it...
Calculate the Date After A Specified Number of Workdays In Excel
If you use Excel to project manage then you will know that most people work a five day week - Monday to Friday (if they are lucky). So if you have a project start date and the number of days it...
Calculating A Percentage Difference In Excel… The Fastest Balls In Wimbledon…
I am a huge tennis fan (in particular Wimbledon), and the speed of the balls amaze me. So, just how much faster were the fastest balls this year in Wimbledon compared to last year?. A good excuse...
Having spikes in your data can sometimes make it difficult to carry out predictive analysis. These spikes can be due to seasonal fluctuations in sales, for example more sales of soft drinks and ice...
So, I am used to talking about weather temperatures in Celsius, some of my friends would do this as well but depending where they are in the world they would talk about Fahrenheit. I talk about a...