Next Live Training Date:

8-12 June, 13-17 July

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.

Excel CAGR formula

Excel CAGR formula
Watch this video

Which function to use to equate to an Excel CAGR formula as there is no in build compound annual growth rate function.

  • 2:01
  • Skill Level:
  • What's my skill level
    Flying screens

    All of our videos are listed by user Excel Skill Level.

    To find out your personal skill level, download our quick assessment.

    Once you've completed the test, send it to us and we'll evaluate for you.

    Download Test

  • Watch this Video

Excel CAGR formula

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

Handy Tips & Tricks

Excel not equal sign

Excel not equal sign If you are using certain formula you may require the Excel not equal sign. In maths the symbol is an equal sign crossed out (≠) but this is not available in Excel. So for example you are … Continue reading

[h]:mm for Powerpivot

[h]:mm for Powerpivot A useful custom format capability in Excel is the [h]:mm:ss which allows you to see how many hours in total have elapsed between two dates by showing hours bigger than 24 (most time formats automatically change back … Continue reading

...After eleven years we still use the model for financial planning and to provide information to the banks. The key feature is the logical layout which makes it easy to understand and adapt on our own, and the flexibility to combine actual and forecast data...

– Financial Model development- SA Prisons

Video Library & Tutorials //

View Entire Video Gallery ››

Tables in Excel for PowerPivot use

Tables in Excel for PowerPivot use

Excel see formula instead of value 2013

Excel see formula instead of value 2013

Excel Quick Sum 2013

Excel Quick Sum 2013

Excel Group Rows 2013

Excel Group Rows 2013

Some of our Featured Clients