Forecasting Models with Excel by Start-Tech Academy

Forecasting Models with Excel

A complete course on understanding Forecasting models to drive business decisions for better profitability

What's included?

Video Icon 41 videos File Icon 1 file

Contents

Introduction
Introduction
4 mins
Course Resourses
2.92 MB
Basics of Forecasting
Basics of Forecasting
6 mins
Creating Linear Model with Trendlines
9 mins
Getting Data Ready for Regression Model
Gathering Business Knowledge
3 mins
Data Exploration
4 mins
The Data and the Data Dictionary
8 mins
Univariate analysis and EDD
4 mins
Discriptive Data Analytics in Excel
11 mins
Outlier Treatment
5 mins
Identifying and Treating Outliers in Excel
5 mins
Missing Value Imputation
4 mins
Identifying and Treating missing values in Excel
4 mins
Variable Transformation in Excel
4 mins
Dummy variable creation Handling qualitative data
5 mins
Dummy Variable Creation in Excel
8 mins
Correlation Analysis
10 mins
Creating Correlation Matrix in Excel
9 mins
Forecasting using Regression Model
The Problem Statement
2 mins
Basic Equations and Ordinary Least Squares (OLS) method
9 mins
Assessing accuracy of predicted coefficients
15 mins
Assessing Model Accuracy: RSE and R squared
8 mins
Creating Simple Linear Regression model
3 mins
Multiple Linear Regression
5 mins
The F - statistic
9 mins
Interpreting results of Categorical variables
6 mins
Creating Multiple Linear Regression model
8 mins
Handling Special events like Holiday sales
Forecasting in presence of special events
3 mins
Excel: Running Linear Regression using Solver
9 mins
Excel: Including the impact of Special Events
23 mins
Identifying Seasonality & Trend for Forecasting
Models to identify Trend & Seasonality
7 mins
Excel: Additive model to identify Trend & Seasonality
10 mins
Excel: Multiplicative model to identify Trend & Seasonality
7 mins
Moving Average Method
2 mins
Excel: Moving Average Method
16 mins
Handling Changing Trend & Seasonality over time
Winter's Method to accomodate changing Trend & Seasonality
7 mins
Excel: Winter's method
13 mins
Forecasting models for New Products
S-curve for New products
8 mins
Excel: Using Logistic curve to model S-curve
9 mins
Excel: Using Gompertz curve to model S-curve
5 mins
Bass Diffusion Model for New Products
9 mins
Excel: Implementing Bass Diffusion Model
16 mins