To read the accompanying Forecasting Sheets in Excel article to this video, go here ️ https://www.simonsezit.com/article/predict-future-values-using-forecast-sheet-in-excel/

If you use Excel 2016, 2019, or Excel for Office 365, you will have access to one of the newer features of Excel: Forecast Sheet. If you have historical time-based data, you can use it to create a forecast and predict future values. A forecast can help you predict trends, future sales, future requirements, and needs so you can make better business decisions.

When you create a forecast, Excel creates a new worksheet that contains a table that includes the historical and predicted values and a chart that shows the data. All with the click of one button.

GET FOUR FREE COURSES https://www.simonsezit.com/four-free-courses

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

Check out our Excel 2021 tutorials for beginners playlist here
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb

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

Watch more popular tutorials from Simon Sez IT:

Microsoft Word 2019 playlist https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jPMO6219NPPGA0WD2Pm0As

Microsoft Project 2019 course playlist https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jo_PtA6h6LNhvMbWNtJsXL

Microsoft Excel 2019 Beginners playlist:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gABy6lbJgp6kZtXVhadATg

Microsoft Excel 2019 Advanced playlist:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gL_KnxdZzkDExVeX5vngx9

GET FOUR FREE COURSES https://www.simonsezit.com/four-free-courses

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
LinkedIn: https://www.linkedin.com/company/simon-sez-it/

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

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)