Question: how to calculate year over year percentage change in excel?
Answer: Find the percentage of change between two numbers On the Home tab, click the Percentage button. If you are using Excel for the web, click Home > Number Format > Percentage. In cell B3, divide the second year's sales ($598,634.00) by the first year ($485,000.00), and then subtract 1. Here's the formula in cell C3.