To download the Excel file and follow along, go here ►
️https://www.simonsezit.com/article/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

Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Check out our free video playlist for Excel beginners https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gABy6lbJgp6kZtXVhadATg

Pivot Table Tutorials for Beginners here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i80FzwXA86zJOK8dtlB-qt

Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

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