Episode # 184 - Straight Line Estimate

Sponsored by

Check out this book for more tips
similar to this lesson!

Tuesday, February 07, 2006

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.

You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 2 minutes to learn this lesson now with our free video!

Watch Video

Click Play icon to play the video. You might first need to click on the Video to activate Flash player.

Tags/Keywords for this video: Formulas

Episode # 184 - Straight Line Estimate

More Excel Video Lessons