Next Live Training Date:

JHB:9-11 May/ DBN:16-18May

Not sure which Excel course you should do? Try out our free Which Excel Course Should you do" questionnaire. 20 questions and you will know exactly what course you should do!

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

Free Tips & Tricks Newsletter

Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!

Handy Tips & Tricks

AE News: Copy cells left, annual interest, Euro 2016 sweepstakes, safe date entry

Popular Which Excel course should YOU do- updated to make the report more easy to find Training Dates Training Course Dates– Durban (Kingsmead) and Cape Town- See below Training Course Dates JHB/ PTA Tips and Tricks Copy a cell to … Continue reading

Copy a cell to the left in Excel

In our courses we often see delegates trying to copy cells to the left and making an incorrect assumption on which part of the cell to click when using the mouse. So in order to copy a cell to the … Continue reading

...AuditExcel are professional, technically competent and provide solution suited to individual business needs. We are still using the reports and the budget tool they designed and have since been able to enhance the reports ourselves

– Spreadsheet budget app- BDO Auditors

Video Library & Tutorials //

View Entire Video Gallery ››

Making the same change to multiple worksheets in Excel

Making the same change to multiple worksheets in Excel

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

Some of our Featured Clients