 |
 |
| About MrExcel |
| Consulting Services |
| Learn Excel Resources |
| Challenge of the Month |
| MrExcel Seminars |
| MrExcel Store |
| Podcast |
| Search |
| Media |
| Contact |
| Home |
 |
| 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! |
Sponsored by: Check out this book for more tips similar to this lesson! (Click the book for details) |
Prev Next
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.
| Your first click will activate the control, then click the play icon to play the video (requires Flash): |
- Excel training videos about Charts
- Excel training videos about VBA
- Excel training videos about Pivot Tables
- Excel training videos about Data Analysis
- Excel training videos about Formulas
- Excel training videos about Formatting
- Excel training videos about Printing
- Excel training videos about Excel 2007
- Index to all videos
MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.