Forecasting Models with Excel (Udemy.com)
Learn main forecasting models and methods from basic to expert level through a practical course with Excel.
Created by: Diego Fernandez
Produced in 2018
What you will learn
- Estimate simple forecasting methods such as arithmetic mean, random walk, seasonal random walk and random walk with drift.
- Evaluate simple forecasting methods forecasting accuracy through mean absolute error, root mean squared error scale-dependent and mean absolute percentage error, mean absolute scaled error scale-independent metrics.
- Approximate simple moving averages and exponential smoothing methods with no trend or seasonal patterns such as Brown simple exponential smoothing method.
- Estimate exponential smoothing methods with only trend patterns such as Holt linear trend, exponential trend, Gardner additive damped trend and Taylor multiplicative damped trend methods.
- Approximate exponential smoothing methods with trend and seasonal patterns such as Holt-Winters additive, Holt-Winters multiplicative and Holt-Winters damped methods.
- Select exponential smoothing method with lowest Akaike, corrected Akaike and Schwarz Bayesian informat
Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 0 / 100
Course Description
Full Course Content Last Update 06/2018
Learn forecasting models through a practical course with Microsoft Excel using S&P 500 Index ETF prices historical data. It explores main concepts from basic to expert level which can help you achieve better grades, develop your academic career, apply your knowledge at work or do your business forecasting research. All of this while exploring the wisdom of best academics and practitioners in the field.
Become a Forecasting Models Expert in this Practical Course with Excel
Estimate simple forecasting methods such as arithmetic mean, random walk, seasonal random walk and random walk with drift.
Evaluate simple forecasting methods forecasting accuracy through mean absolute error, root mean squared error scale-dependent and mean absolute percentage error, mean absolute scaled error scale-independent metrics.
Approximate simple moving averages and exponential smoothing methods with no trend or seasonal patterns such as Brown simple exponential smoothing method.
Estimate exponential smoothing methods with only trend patterns such as Holt linear trend, exponential trend, Gardner additive damped trend and Taylor multiplicative damped trend methods.
Approximate exponential smoothing methods with trend and seasonal patterns such as Holt-Winters additive, Holt-Winters multiplicative and Holt-Winters damped methods.
Select exponential smoothing method with lowest Akaike, corrected Akaike and Schwarz Bayesian information loss criteria.
Identify Box-Jenkins autoregressive integrated moving average model integration order through level and differentiated first order trend stationary time series deterministic test and Phillips-Perron unit root test.
Recognize autoregressive integrated moving average model autoregressive and moving average orders through autocorrelation and partial autocorrelation functions.
Estimate non-seasonal autoregressive integrated moving average models such as random walk with drift, differentiated first order autoregressive, Brown simple exponential smoothing, simple exponential smoothing with growth, Holt linear trend and Gardner additive damped trend models.
Approximate seasonal autoregressive integrated moving average models such as seasonal random walk, seasonal random trend and seasonally differentiated first order autoregressive models.
Choose autoregressive integrated moving average model with lowest Akaike, corrected Akaike and Schwarz Bayesian information loss criteria.
Assess highest forecasting accuracy autoregressive integrated moving average model residuals or forecasting errors white noise requirement through Ljung-Box lagged autocorrelation test.
Become a Forecasting Models Expert and Put Your Knowledge in Practice
Learning forecasting models is indispensable for business or financial data science applications in areas such as sales and financial forecasting, inventory optimization, demand and operations planning, and cash flow management. It is also essential for academic careers in data science, applied statistics, operations research, economics, econometrics and quantitative finance. And its necessary for business forecasting research.
But as learning curve can become steep as complexity grows, this course helps by leading you step by step using S&P 500 Index ETF prices historical data for forecast modelling to achieve greater effectiveness.
Content and Overview
This practical course contains 42 lectures and 8 hours of content. Its designed for all forecasting models knowledge levels and a basic understanding of Microsoft Excel is useful but not required.
At first, youll learn how to perform forecasting models operations using built-in functions and array calculations. Next, youll learn how to do optimal parameter estimation or fine tuning and linear regression calculation using Microsoft Excel Add-ins.
Then, youll define simple forecasting methods such as arithmetic mean, random walk, seasonal random walk and random walk with drift. Next, youll evaluate simple methods forecasting accuracy through scale-dependent and scale-independent error metrics. For scale-dependent metrics, youll define mean absolute error and root mean squared error. For scale-independent metrics, youll define mean absolute percentage error and mean absolute scaled error.
Next, youll define simple moving averages and exponential smoothing methods. For exponential smoothing methods with no trend or seasonal patterns, youll define Brown simple exponential smoothing method. For exponential smoothing methods with only trend patterns, youll define Holt linear trend, exponential trend, Gardner additive damped trend and Taylor multiplicative damped trend methods. For exponential smoothing methods with trend and seasonal patterns, youll define Holt-Winters additive, Holt-Winters multiplicative and Holt-Winters damped methods. After that, youll select exponential smoothing method with lowest information loss criteria. For information loss criteria, youll define Akaike, corrected Akaike and Schwarz Bayesian information loss criteria. Later, youll evaluate simple moving average and exponential smoothing methods forecasting accuracy through scale-dependent and scale-independent error metrics. For scale-dependent metrics, youll define mean absolute error and root mean squared error. For scale-independent metrics, youll define mean absolute percentage error and mean absolute scaled error.
After that, youll define Box-Jenkins autoregressive integrated moving average models. Then, youll identify autoregressive integrated moving average model integration order through level and differentiated time series first order trend stationary deterministic test and Phillips-Perron unit root test. Next, youll identify autoregressive integrated moving average model autoregressive and moving average orders through autocorrelation and partial autocorrelation functions. For non-seasonal autoregressive integrated moving average models, youll define random walk with drift, differentiated first order autoregressive, Brown simple exponential smoothing, simple exponential smoothing with growth, Holt linear trend and Gardner additive damped trend models. For seasonal autoregressive integrated moving average models, youll define seasonal random walk, seasonal random trend and seasonally differentiated first order autoregressive models. After that, youll select autoregressive integrated moving average model with lowest information loss criteria. For information loss criteria, youll define Akaike, corrected Akaike and Schwarz Bayesian information loss criteria. Later, youll evaluate models forecasting accuracy through scale-dependent and scale-independent error metrics. For scale-dependent metrics, youll define mean absolute error and root mean squared error. For scale-independent metrics, youll define mean absolute percentage error and mean absolute scaled error. Finally, youll assess highest forecasting accuracy autoregressive integrated mov
Learn forecasting models through a practical course with Microsoft Excel using S&P 500 Index ETF prices historical data. It explores main concepts from basic to expert level which can help you achieve better grades, develop your academic career, apply your knowledge at work or do your business forecasting research. All of this while exploring the wisdom of best academics and practitioners in the field.
Become a Forecasting Models Expert in this Practical Course with Excel
Estimate simple forecasting methods such as arithmetic mean, random walk, seasonal random walk and random walk with drift.
Evaluate simple forecasting methods forecasting accuracy through mean absolute error, root mean squared error scale-dependent and mean absolute percentage error, mean absolute scaled error scale-independent metrics.
Approximate simple moving averages and exponential smoothing methods with no trend or seasonal patterns such as Brown simple exponential smoothing method.
Estimate exponential smoothing methods with only trend patterns such as Holt linear trend, exponential trend, Gardner additive damped trend and Taylor multiplicative damped trend methods.
Approximate exponential smoothing methods with trend and seasonal patterns such as Holt-Winters additive, Holt-Winters multiplicative and Holt-Winters damped methods.
Select exponential smoothing method with lowest Akaike, corrected Akaike and Schwarz Bayesian information loss criteria.
Identify Box-Jenkins autoregressive integrated moving average model integration order through level and differentiated first order trend stationary time series deterministic test and Phillips-Perron unit root test.
Recognize autoregressive integrated moving average model autoregressive and moving average orders through autocorrelation and partial autocorrelation functions.
Estimate non-seasonal autoregressive integrated moving average models such as random walk with drift, differentiated first order autoregressive, Brown simple exponential smoothing, simple exponential smoothing with growth, Holt linear trend and Gardner additive damped trend models.
Approximate seasonal autoregressive integrated moving average models such as seasonal random walk, seasonal random trend and seasonally differentiated first order autoregressive models.
Choose autoregressive integrated moving average model with lowest Akaike, corrected Akaike and Schwarz Bayesian information loss criteria.
Assess highest forecasting accuracy autoregressive integrated moving average model residuals or forecasting errors white noise requirement through Ljung-Box lagged autocorrelation test.
Become a Forecasting Models Expert and Put Your Knowledge in Practice
Learning forecasting models is indispensable for business or financial data science applications in areas such as sales and financial forecasting, inventory optimization, demand and operations planning, and cash flow management. It is also essential for academic careers in data science, applied statistics, operations research, economics, econometrics and quantitative finance. And its necessary for business forecasting research.
But as learning curve can become steep as complexity grows, this course helps by leading you step by step using S&P 500 Index ETF prices historical data for forecast modelling to achieve greater effectiveness.
Content and Overview
This practical course contains 42 lectures and 8 hours of content. Its designed for all forecasting models knowledge levels and a basic understanding of Microsoft Excel is useful but not required.
At first, youll learn how to perform forecasting models operations using built-in functions and array calculations. Next, youll learn how to do optimal parameter estimation or fine tuning and linear regression calculation using Microsoft Excel Add-ins.
Then, youll define simple forecasting methods such as arithmetic mean, random walk, seasonal random walk and random walk with drift. Next, youll evaluate simple methods forecasting accuracy through scale-dependent and scale-independent error metrics. For scale-dependent metrics, youll define mean absolute error and root mean squared error. For scale-independent metrics, youll define mean absolute percentage error and mean absolute scaled error.
Next, youll define simple moving averages and exponential smoothing methods. For exponential smoothing methods with no trend or seasonal patterns, youll define Brown simple exponential smoothing method. For exponential smoothing methods with only trend patterns, youll define Holt linear trend, exponential trend, Gardner additive damped trend and Taylor multiplicative damped trend methods. For exponential smoothing methods with trend and seasonal patterns, youll define Holt-Winters additive, Holt-Winters multiplicative and Holt-Winters damped methods. After that, youll select exponential smoothing method with lowest information loss criteria. For information loss criteria, youll define Akaike, corrected Akaike and Schwarz Bayesian information loss criteria. Later, youll evaluate simple moving average and exponential smoothing methods forecasting accuracy through scale-dependent and scale-independent error metrics. For scale-dependent metrics, youll define mean absolute error and root mean squared error. For scale-independent metrics, youll define mean absolute percentage error and mean absolute scaled error.
After that, youll define Box-Jenkins autoregressive integrated moving average models. Then, youll identify autoregressive integrated moving average model integration order through level and differentiated time series first order trend stationary deterministic test and Phillips-Perron unit root test. Next, youll identify autoregressive integrated moving average model autoregressive and moving average orders through autocorrelation and partial autocorrelation functions. For non-seasonal autoregressive integrated moving average models, youll define random walk with drift, differentiated first order autoregressive, Brown simple exponential smoothing, simple exponential smoothing with growth, Holt linear trend and Gardner additive damped trend models. For seasonal autoregressive integrated moving average models, youll define seasonal random walk, seasonal random trend and seasonally differentiated first order autoregressive models. After that, youll select autoregressive integrated moving average model with lowest information loss criteria. For information loss criteria, youll define Akaike, corrected Akaike and Schwarz Bayesian information loss criteria. Later, youll evaluate models forecasting accuracy through scale-dependent and scale-independent error metrics. For scale-dependent metrics, youll define mean absolute error and root mean squared error. For scale-independent metrics, youll define mean absolute percentage error and mean absolute scaled error. Finally, youll assess highest forecasting accuracy autoregressive integrated mov
Instructor Details
- 0.0 Rating
0 Reviews
Diego Fernandez
Diego Fernandez is author of high-quality online courses and ebooks at Exfinsis for anyone who wants to become an expert in financial data analysis.
His main areas of expertise are financial analysis and data science. Within financial analysis he has focused on computational finance, quantitative finance and trading strategies analysis. Within data science he has concentrated on machine learning, applied statistics and econometrics. For all of this he has become proficient in Microsoft Excel, R statistical software and Python programming language analysis tools.
He has important online business development experience at fast-growing startups and blue-chip companies in several European countries. He has always exceeded expected professional objectives by starting with a comprehensive analysis of business environment and then efficiently executing formulated strategy.
He also achieved outstanding performance in his undergraduate and postgraduate degrees at world-class academic institutions. This outperformance allowed him to become teacher assistant for specialized subjects and constant student leader within study groups.
His motivation is a lifelong passion for financial data analysis which he intends to transmit in all of the courses.
More excel courses
Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (2021)
4.9 (216 Reviews)
Provider: Udemy
Time: 7h
$11.99
Visually Stunning Microsoft Excel Dynamic Dashboard Course (2021)
4.9 (193 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Microsoft Excel Complete Excel Guide (Excel 2007 2021) (2021)
4.9 (62 Reviews)
- Provider: Udemy
- Time: 21h
$11.99
Reviews
- Video Duration:
8h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2018 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
