Learn Excel Episode 184: Straight Line Estimate

Posted in Companies, Podcasts on June 29, 2008


Learn Excel Episode 184: Straight Line Estimate

One of the simplest ways of forecasting is to assume that the sales are increasing along a straight trendline. Excel offers a function to calculate a trendline, but it is one of the most bizarre functions. If you don't know the secret to using LINEST, it will try and describe a line with a single value, like "208". This is enough to confuse even the rocket scientists. Let MrExcel show you the simple (but non-intuitive) steps to entering an array formula. Episode 184 will show you how.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel