Business Forecasting Techniques with Excel
Business Forecasting Techniques with EXCEL
2-Day Professional Development Workshop
East Asia Training & Consultancy Pte Ltd invites you to attend a two-day professional development workshop using Excel and other proprietary forecasting software to forecast models.
Course Outline
In this public course, you will learn how to forecast without data (Delphi and Expert methods), forecast with historical data (time-series, Box-Jenkins ARIMA, GARCH, time-series regression, nonlinear regression, autoregressive processes), forecast with contemporaneous data (multiple nonlinear regression, ARIMAX, principal components, stepwise regression), and forecast with comparable data or subjective assumptions (nonparametric and parametric simulation).
The course will run for 2 days and will cover the following topics:
- ARIMA Box-Jenkins and ARIMAX
- Delphi Method
- Expert Consensus Method
- Multivariate Regression
- Regression Diagnostics (multicollinearity, heteroskedasticity, autocorrelation)
- Simulation (parametric and nonparametric)
- Stepwise Regression
- Time-Series Forecasting
- Time-Series Regression
This course will be hands-on. Each participant is required to bring their own laptops.