Discover insights with business forecasts – Improve your strategic decisions with accurate data and advanced analytics.
Suggested by: Coursera (What is Coursera?)
No prior knowledge required
No unnecessary risks
The current situation in the world makes business forecasting a central element for the functioning of institutions. In this specialization, we will focus on Excel skills in business forecasting in three courses:
We will look at how your business can use time series data to understand the different components behind that data, and then implement the relevant model based on those components.
We will build causal models for time series data as well as cross-categorical data. Causal models allow us to develop additional strategic understandings by controlling for inputs.
We will explore the role of judgmental forecasts when quantitative forecasting methods encounter limitations. We will explore methodologies for creating judgmental business forecasts and see how Excel can help us make these judgments.
Working with data sets similar to those typically found in business, you will use quantitative and qualitative forecasting techniques to produce business forecasts. Create graphs to simulate data and forecasts, calculate model errors, and use optimization techniques to minimize these errors.
Course 1
11 hours
4.9 (211 ratings)
This course explores different methods for business forecasting in time series. The course includes a variety of business forecasting methods for different types of components found in time series data—levels, trends, and seasonality. We will learn about theoretical methods and apply them to business data using Microsoft Excel.
Course 2
9 hours
4.9 (100 ratings)
This course allows you to learn regression models in order to use these models for business forecasting. We will explore simple regression models, multiple regression models, regressions with dummy variables, regressions with seasonal variables, and autoregressions.
Course 3
10 hours
4.5 (53 ratings)
In this course, we will expand your expertise in business forecasting from the first two. We will examine several structured methodologies for creating judgmental business forecasts, using business metrics, subjective assessment methods, and exploratory methodologies.
