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
FV function not working In the example below it appears that the FV function is not working. When you calculate FV (future value) manually with an amortisation table the answer differs from the FV formula in Excel. So manually for 4 years … Continue reading
Vlookup multiple criteria A common query is how to Vlookup multiple criteria to extract an answer from a list. Although there are complex ways to do this we prefer the simplest way which in our mind means creating another column … Continue reading
It was most interesting and filled with very useful and relevant tricks and tools that one can start to use immediately. The course was well constructed with a logical flow to be able to reference information easily in the take home materials, with exercises covering many different scenarios.– Hyatt Hotels