With trendlines, Excel can project future figures based on previous history. Mary Ann Richardson points the way. Let’s say you are keeping track of monthly sales figures for the past six months ...
Simple moving averages are easily implemented in Excel. Figure 5 shows the Format Trendline dialog box in which you can insert a moving average forecast and include more periods if necessary.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback