Next Live Training Date:

11-15 Aug 2014 JHB

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

Accounting for dummies

Accounting for dummies There are many users of Excel who need to read, interpret and analyse financial statements. But, without a solid accounting knowledge, accounting jargon sounds threatening and balance sheets and income statements can be intimidating. You may feel … Continue reading

Pivot table not pulling all data

Pivot table not pulling all data Pivot tables are great tools but due to the lack of understanding of how they work we are often told that the pivot table is not pulling all the data. There could be a … Continue reading

I actually told Gavin this morning that I want to send you an e-mail. It was excellent. I have personally asked most of the people who were there what they thought about it, and everybody was really positive and confirmed that they learned a lot.

– Melco Conveyor Equipment (Pty) Ltd

Video Library & Tutorials //

View Entire Video Gallery ››

Clean excel data in as few steps possible

Clean excel data in as few steps possible

Solver Excel 2013

Solver Excel 2013

Offset Excel 2013

Offset Excel 2013

Vlookup Approximate Match

Vlookup Approximate Match

Some of our Featured Clients