Another easy method to calculate Compounded annual growth rate (CAGR) in Excel is by using the POWER function. The POWER function replaces the^operator in the CAGR function. The syntax of the POWER function: =POWER(number,power) Arguments of the POWER function: number– It is the base numbe...