Basic Forecasting in Excel Tutorial (SLOPE, INTERCEPT, FORECAST.LINEAR, TREND, Forecast Sheets)

✅ To download the Excel file and follow along, go here ►

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

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[tarekalsherif]

Thank you so much for the very nice explanation!

[anassbadraoui]

love this video, but idk why I don't have the forecast sheet in my Excel ! I do have the most recent version.

[davidferrick]

The trend function requires anchoring the x's and y's.

[darrylmorgan]

Really Nice Tutorial..Thank You Deb :)

[ronniewest]

Thank You Deborah, have watched 3 of your videos and do the excel assignment with you, all outstanding, we have showed me so much, thanks for you hard work and teaching, my favorite teacher.

[bincybimmi]

How we can forecast for upcoming year based on current year ?

[leecurcio]

you are not forecasting. You are saying it can go up, down, or the same. That is not forecasting