FORECASTING using MS EXCEL

TOPICS OF FORECASTING using MS EXCEL

➣Basic Forecasting Methods

➣ARIMA / Box Jenkins

➣Monte Carlo Simulation

➣Simple Linear Regression for Forecasting

➣K Nearest Neighbors

➣Neural Network with MS Excel

➣Markov Chain with MS Excel

➣Bayes Theorem with MS Excel

TRAINING HIGHLIGHTS

➣The training curriculum is designed to prepare the participants to explore ARIMA and Simple Linear Regression for Forecasting.

➣Participants will be provided enough examples and illustrations to analyze and perform ARIMA

➣Usage of Real Time Example and Case study provide confidence to the participants

➣Data from one or more areas of interest can be taken as a case study for a detailed Forecasting.

➣All calculations and analysis are done using MS EXCEL 2010. The spread sheets used for the training will be shared with the participants.

➣The course is participative

PRE REQUISITES

Participants are not expected to have any formal forecasting experience

DETAILED COURSE content

TOPICS covered

Moving Average Exponential Smoothing Holts Method and Holts Winters Bayes Theorem
Arima Modeling Subjective Method Objective Method Monte Carlo Simulation
Simple Linear Regression K Nearest Neighbors Neural Network Markov Chain

Note - Course content and topics to be covered in the training can be customized as per requirement for Corporates.

Faculty profile

FEES for Corporates

Based on the syllabus, contents and other requirements for the corporate training, scope with detailed inclusions and exclusions along with the fee will be shared. There will be a 14% service tax over and above the training fee.