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!
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!
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
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