Not sure which of these videos to watch? Try out our 'Which Excel Formula to Use' App to get guidance. NOTE: All these free Excel video tutorials are streamed via YouTube. If your network does not allow YouTube videos, you can access the video via your smartphone or from a different network.
Which function to use to equate to an Excel CAGR formula as there is no in build compound annual growth rate function.
In this example we have the sales figures for a five year period, and what we want to know is what constant growth rate, results in the sales figure going from about 8700 to 18700. We would like to us the Excel CAGR formula.
We can use the RATE function to find this out, so
It is always useful to prove your calculations, so what we want to see is whether our interest rate grows steadily to the end amount, so what we can say is
Excel not adding properly- nonsensical results (that change as well) Excel not adding properly and giving a nonsensical result? Something like 10 + 10 = 0 (and it gives you a warning message) or 10 + 10 = 2 000 … Continue reading
Excel not adding correctly- Out by 1 c Excel not adding correctly? Perhaps it is out by 1 c when you try and add up the decimals. The most common reason for this is that the numbers really contain more … Continue reading
"Adrian and Team. Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude towards De Wet, who hosted the Excel Advanced course.– Gill Robbetze Lonmin