Question: how to calculate percent change over time in excel?
Answer: Select a blank cell for locating the calculated percentage change, then enter formula =(A3-A2)/A2 into the Formula Bar, and then press the Enter key. ...  Keep selecting the result cell, then click the Percent Style button in the Number group under Home tab to format the cell as percentage.