How to do sales forecasting in Excel: Step-by-step Create a new Excel worksheet. Open a new Excel spreadsheet and enter your historical data (sales over time). ... Create your forecast. Go to the Data tab and find the Forecast Sheet option. ... Adjust your sales forecast. ... View your ready sales forecast.