Dive into advanced Excel forecasting techniques in this 25-minute tutorial. Learn to predict trends and seasonal patterns using linear regression methods. Master the use of the FORECAST function and Data Analysis Regression Feature for simple and multiple linear regression. Explore how to forecast trends with seasonal patterns using categorical variables and quantitative data. Gain practical skills in applying VLOOKUP and MATCH functions with mixed cell references to populate categorical variable columns. Download the accompanying Excel files to follow along and practice these powerful business analytics tools for more accurate forecasting and decision-making.
Basic Excel Business Analytics - Forecasting with Linear Regression: Trend & Seasonal Pattern
ExcelIsFun via YouTube
Overview
Syllabus
) Forecasting using Regression when we see a trend and belief the trend will extend into the future. Will will predict outside the Experimental Region with the Assumption is that trend continues into future..
) Forecast a Trend using Simple Liner Regression. We use the Data Analysis Regression Feature..
) Learn how to use FORECAST function..
) Forecast a Seasonal Pattern using Multiple Regression and three Categorical Variables for quarter using Multiple Linear Regression. We use the Data Analysis Regression Feature..
) VLOOKUP & MATCH functions with Mixed Cell References to populate new categorical variable columns with the Boolean ones and zeroes..
) Forecast a Trend with a Seasonal Pattern using Multiple Regression and three Categorical Variables for quarter and one quantitative variable using Multiple Linear Regression. We use the Data Analysis Regression Feature..
Taught by
ExcelIsFun
