Forecasting with Microsoft Excel
3.8 (19 ratings)
2,338 students enrolled

# Forecasting with Microsoft Excel

Spend less than an hour and learn how to forecast business indicators using MS Excel
3.8 (19 ratings)
2,338 students enrolled
Created by Alex Akhunov
Last updated 5/2018
English
English [Auto-generated]
Current price: \$129.99 Original price: \$199.99 Discount: 35% off
8 hours left at this price!
30-Day Money-Back Guarantee
This course includes
• 44 mins on-demand video
• Access on mobile and TV
• Assignments
• Certificate of Completion
Training 5 or more people?

What you'll learn
• 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
Requirements
• Basic MS Excel skills
• High school calculus
• High school statistics
Description

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.

Who this course is for:
• Students
• Entrepreneurs
• Consultants
• Salespersons
Course content
Expand all 5 lectures 44:09
+ Introduction
1 lecture 09:40

This lecture will equip you with basic forecasting skills in Microsoft Excel. You will be able to estimate linear trends over time for sales, revenue, and other indicators.

Preview 09:40
+ Seasons
1 lecture 10:56

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!

Seasons in forecasting
10:56
+ Theory of forecasting
1 lecture 05:21

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.

Preview 05:21
+ Range forecasting
2 lectures 18:12

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.

LINEST function
07:56

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.

Range forecast: how to make a confidence interval
10:16
Donwload a dataset 'project.xlsx' and make (1) a single-point forecast, (2) a range forecast at 90% confidence level, (3) a range forecast at 95% confidence level, (4) a range forecast at 99% confidence level.
Forecasting project
10 questions