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
Conditional formatting greyed out in Excel Conditional formatting greyed out in Excel is typically as a result of the workbook being a shared workbook. To check whether you have the shared workbook feature switched on, go to the REVIEW tab and … Continue reading
Filter by color option not available With the data autofilter you may discover that filter by color option is not available. There are a couple of possible reasons for this. The first reason is if there is only one colour … Continue reading
I actually told Gavin this morning that I want to send you an e-mail. It was excellent. I have personally asked most of the people who were there what they thought about it, and everybody was really positive and confirmed that they learned a lot.– Melco Conveyor Equipment (Pty) Ltd