Formula Archives

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...

Calculate A Moving Average In Excel

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...

Convert Temperatures Easily In Excel

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...

Use GoTo To Quickly Navigate Large Excel Workbooks

I want to share with you a tip that I use most days if my rows of data are more than a few hundred lines (which is most days!!). It's the Go To feature where you can specify an exact cell location...

Let’s Look At The MIN and MAX Functions In Excel

I touched briefly on the MIN and MAX functions in my recent How To Excel At Excel Newsletter. If you want to sign up for 3 top tips every 15 days then just enter your email address here and as...

GETPIVOTDATA when you don’t want to?….

Have you found when you try to reference a cell in a Pivot Table that Excel will sometimes automatically creates a cell reference with the prefix GETPIVOTDATA? ......even when you just want a simple...