Basic Forecasting in Excel: Recorded Webinar
In this Excel tutorial, we take you through some of the formulas and functions you can use to perform basic forecasting in Excel.
Forecasting is essential to make sure you plan correctly in business and is used everywhere. Excel is packed with forecasting formulas and functions aimed at helping you predict future results based on existing data.
Once again, this Excel Pivot Tables advanced tutorial was hosted by the excellent Deborah Ashby for Simon Sez IT.
In this basic forecasting in Excel class we look at:
- What is forecasting?
- The different types of forecasting
- Forecasting in Excel using the SLOPE and INTERCEPT functions
- Forecasting in Excel using the FORECAST.LINEAR function
- Using Named Ranges to make forecasting easier
- Using Array functions and TREND to forecast
- Forecast Sheets (aka, one-click forecasting)
- Forecast Charts
DOWNLOAD THE EXCEL FILE and follow along
If you are interested in learning more about Advanced Microsoft Excel. Then take a look at the following free resources:
- Predict future values using Forecast Sheet in Excel
- Getting started with 3D maps in Excel
- Getting started with Power Pivot
- Creating a Dynamic Drop Down List in Excel
- VLOOKUP for Dummies
Adam Lacey
Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats. When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.