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
Compare 3 variables in excel A common requirement from training delegates is to compare 3 variables in excel. With use of the correct formula this is fairly easy. The first option is using the IF function (watch the IF function … Continue reading
Text footer excel A number of clients have queried the text footer excel limits on the number of characters allowed. For example, if you want to include some terms and conditions as a footer to all printed pages you will … 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