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!
If you are an engineer or scientist and you make use of spreadsheets (who doesn’t) then it is useful to know what your shortcomings are and how to address them. In the article ‘The Do’s and Don’ts Of Engineering Spreadsheets’, the … Continue reading
Zero is an interesting number in Excel (and in mathematics in general) and causes lots of problems for a ‘nothing’ number. Below some quick tips on dealing with zero in Excel. Hide/ Show Zero in Excel- Change the options If … Continue reading
...Not only did I learn a lot about Access on this course, but I also gained quite a few useful Excel skills. The fact that Jonny is an accountant meant that he understood the daily challenges with data in a finance role...– Excel with access- Hannover Re