how to calculate percent change in excel organize your data with the years across the top and your numeric value directly below on the line create a new value called change calculate percentage differ.

how to remove subtotals in excel now you can choose what is the column that you want to group at each change in in this case is the store column what is the function you want to use remove subtotals p.