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
Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Data table all same values When first using Data Tables in Excel you may come across a situation where you feel you have done everything correctly, yet the data table is clearly wrong as all the numbers in the middle … Continue reading
A Testing Time for Spreadsheets A recent article from Financial Times ( A Testing Time for Spreadsheets ) highlights the risks associated with incorrect spreadsheet use. As correctly stated in the article, the only true way to combat this is … Continue reading
... I have always found them to be very adaptable to the various clients we send them to and they are able to solve the most complex of modelling problems...– Investment property spreadsheets- Old Mutual