The Classic Formula no shortcut calculate the rate of change in excel. The percent change formula is used very often in Excel. The RATE function syntax has the following arguments.
For example to calculate the Monthly Change and Total Change.
The formula for calculating change is new value old value old value. Copy the dotted formula beware of the format Like all the formulas in Excel you can easily drag-and-drop the fill-handle to copy the formula. The percent change formula is used very often in Excel. You can use RATE to calculate the periodic interest rate then multiply as required to derive the annual interest rate.