You’ll find three of them — Goal Seek, Scenario Manager, and Data Tables — under the Data tab, within the Forecast group, ...
To calculate a company's forward P/E, divide the current share price by the estimated future earnings per share. Many investors use an Excel spreadsheet to calculate a company's forward P/E and to ...