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.
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
Accessing the task manager from excel A nice shortcut from @TomUrtis shows a quick way to get access the Task Manager from Excel. Normally trying to access the Task Manager is a bad sign in Excel, and in fact you can’t do anything … Continue reading
Excel Quiz Answers Answers for the quiz on our 11 Dec 2014 Newsletter. To subscribe to the newsletter visit the subscribe page. Excel Questions 1) The biggest risk with linking spreadsheets together is a. Rows and columns are added/ deleted when … Continue reading
....As an example, the training in VLOOKUP had applicability in differing ways for each employee and they learned then and there how to use it in their own work. They left the training with clear expectations on improvement in their areas of responsibility...– Benefits of inhouse training- Health and Accident Underwriting Managers