Sales Forecasting Using Excel. Microsoft Excel is a useful tool for tracking data. By providing past sales data and other factors that affect your sales, you can use Excel's Forecast function to ...