Being a psychic isn’t necessary for predicting future sales. All you need is your past sales data and Excel. Excel will do the work for you — no programming or math degree required. For best results, collect more than a year’s worth of data for your baseline. Otherwise, seasonal sales could be mistaken for long-term sales. The order of your data should be the earliest sales to the most recent sales. You will also need to compare weeks with weeks and not weeks with months. Tips Writer Bio

How to Make Graphs for Forecasting Sales in Excel - 69