Calculating CAGR or Compound Annual Growth Rate in Microsoft Excel is super easy. You will have to use the RRI function to get the job done.

Excel offers three functions for calculating the internal rate of return, and I recommend you use all three.