Forecasting with Microsoft Excel
- 44 mins on-demand video
- 4 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- You will know how to use TREND and FORECAST functions in MS Excel
- You will be able to make a forecast for sales, revenue and other simple indicators
- You will be able to make a single-point forecast
- You will learn how to estimate deviations from the single-point forecast
- Basic MS Excel skills
- High school calculus
- High school statistics
This short course will equip you with simple tools that we use to make forecasts. Also, you will also learn more complicated a range forecast. This forecast requires a predicted single-point and estimated deviations from this point compared to simple single-point forecasts in Excel. The range forecast provides more accurate predictions, and it is more valuable for decision making in business. I will show you how to do it in MS Excel in 60 minutes.
- Fresh graduates
- Small business owners
This lesson will teach you how to make a more accurate forecast. To provide better predictions, we need to take into account seasons. For example, ice-cream sales are higher during summertime and lower during winter. The ice-cream sales might grow over time. However, they are lower in winter and higher in summer. An accurate forecast has to take into account these fluctuations. We will learn how to do this in this part!
This lecture explains how TREND and FORECAST formulas work in MS Excel. We need to cover this topic to make a range forecast in future. I won't tell a lot about the theory. Instead, I am talking about general principles to get theoretical ideas.
This lecture shows how to make a forecast manually. It means that you can use LINEST formula to make a forecast in addition to TREND and FORECAST formulas. This topic is essential to understand how forecasting works in MS Excel and to construct a range forecast in future. Please watch this video before making a range forecast.
This video finalises the forecasting course. I will show you how to make a range forecast. This type of forecast assumes that there are deviations near the single-point forecast. Since it makes sense to estimate these deviations to understand how the forecast is accurate. Moreover, this type of information is essential for strategy and risk management. Usually, we deal with ranges instead of a single-point forecast.