How to Calculate Sales Forecasting Using Excel. When you're working on sales forecasts, Microsoft Excel can take care of all of the calculations for you. Most sales forecasts require two types of ...