Forecasting in Excel Made SIMPLE (include seasonality & make predictions)
Get Access to My Course "Fundamentals of Financial Analysis" HERE: https://www.xelplus.com/course/learn-financial-analysis/
In this video I'll show you how easy it is to create a forecast in Microsoft Excel. A forecast can help you predict things like future sales, inventory requirements, or consumer trends based on historical data. We'll use The Home Depot's quarterly sales data to make predictions for the upcoming quarters.
You'll learn how to use Excel's Forecast Sheet. This feature turns historical data into accurate predictions with just a few clicks. This is especially helpful when you're working with seasonal data.
This feature is available in Excel 2016 and higher. It automatically creates formulas with the FORECAST.ETS function with its exponential triple smoothing algorithm.
🌍 My Online Excel Courses ► https://www.xelplus.com/courses/
00:00 How to Do Forecasts in Excel
00:37 Analyzing Historical Data
01:24 How to Use the Forecast Sheet
04:54 Wrap Up
Blog post and workbook: https://www.xelplus.com/forecasting-in-excel-made-simple/
🎬 LINKS to related videos:
Percentile in Excel: https://youtu.be/U-5iQpz3C5I
Excel for Accounting: https://youtu.be/m_SH0TOLsIc
🎒 Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
📚 Excel RESOURCES I Recommend: https://www.xelplus.com/resources/
🎥 GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
Видео Forecasting in Excel Made SIMPLE (include seasonality & make predictions) канала Leila Gharani
In this video I'll show you how easy it is to create a forecast in Microsoft Excel. A forecast can help you predict things like future sales, inventory requirements, or consumer trends based on historical data. We'll use The Home Depot's quarterly sales data to make predictions for the upcoming quarters.
You'll learn how to use Excel's Forecast Sheet. This feature turns historical data into accurate predictions with just a few clicks. This is especially helpful when you're working with seasonal data.
This feature is available in Excel 2016 and higher. It automatically creates formulas with the FORECAST.ETS function with its exponential triple smoothing algorithm.
🌍 My Online Excel Courses ► https://www.xelplus.com/courses/
00:00 How to Do Forecasts in Excel
00:37 Analyzing Historical Data
01:24 How to Use the Forecast Sheet
04:54 Wrap Up
Blog post and workbook: https://www.xelplus.com/forecasting-in-excel-made-simple/
🎬 LINKS to related videos:
Percentile in Excel: https://youtu.be/U-5iQpz3C5I
Excel for Accounting: https://youtu.be/m_SH0TOLsIc
🎒 Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
📚 Excel RESOURCES I Recommend: https://www.xelplus.com/resources/
🎥 GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
Видео Forecasting in Excel Made SIMPLE (include seasonality & make predictions) канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Useful Websites to Use Today #shortsCool Excel Trick 💡Use Slicer Buttons With a Hidden Pivot Table #shortsEasiest Ways to Export Power BI to Excel Smoothly and Efficiently (new updates included 🪄)Introducing Python in Excel 😱Amazing Windows Shortcuts You Aren't Using🆕 Best NEW Excel Features EVERYONE NeedsSecret FREE Windows Tools Nobody Is Talking AboutHow to Use Excel's NEW Lookup of Images 👉 Professional Dashboards Just Got Easy ➕ Bonus RevealWhat Top Doctors Can Teach You About Excel Power Query #shortsYou WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯The Secret to Note-taking for Busy PeopleHow to Split Text with Multiple Delimiters with Excel TEXTSPLIT #shortsAnnouncing the LG supporter squad 😎How to Use Excel's New TAKE Function to Impress Your Boss and ColleaguesYou Won't Believe These Crazy PIVOT TABLE Hacks!Resize Multiple Images At Once #shorts3 Ways to Use Forms in Your Business from Polls to Recruiting + AI Features Revealed!How to Use VSTACK HSTACK Function in Excel #shortsPaste Text ONLY - NEW Shortcut in Word #shorts5 Cool Websites When You Are Bored (Watching Free Movies Included 🍿)How to Use TAKE Function in Excel #shorts