Part 3
Making a Basic Forecast
IN THIS PART …
Excel has some powerful tools to help you make your forecasts. One of them is the PivotTable, which organizes your sales history for you and makes creating your baseline a snap. Another is the PivotChart — it’s hard to overemphasize how important a chart is to understand what’s going on with your sales. If you can visualize it, you’re a lot closer to understanding it. Part 3 also introduces you to the Data Analysis add-in (which has tools that help you make basic forecasts from one variable) and to regression analysis (a way to forecast sales using some other variable).
Get Excel Sales Forecasting For Dummies, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
