To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts ... Finally, you can customize the graph as per your requirements.

simply divide its market price per share by its EPS over a certain fiscal period. Explaining How to Calculate Price-to-Earnings Ratio in Excel Assume you want to compare the P/E ratio between two ...