Practical Forecasting with Excel

What you’ll learn
Make analysis of historical data and select most suitable forecasting method for data analysis
Fit forecasting methods to data, and predict future values
Acquire practical skills to implement different forecasting methods in Excel
Learn most effective ways to build practical forecasting models in Excel.

Requirements
No Excel and forecasting experience required. You will learn everything you need

Description
Almost all types of risks can be caused by uncertainty of the future. Two major different ways how we can deal with uncertainty are forecasting of the future based on historical data and simulation technique, basically – Monte Carlo simulations. Sometimes we can use both of the methods together, especially if we are building models with stochastic processes.During this course we are considering how to build forecasting models in Microsoft Excel. Instead of Excel can be used any spreadsheet software, including Google Sheets – won’t be any difference. This forecasting models can be applied to different fields of business administration or even other spears of science and industries, like biology, chemistry, medicine, etc. You use them in project management, budgeting process and different fields of finance, marketing engineering and pricing, including revenue management, etc.The course is designed to help data analysts, all business practitioners, or students to build broad the range of forecasting models in Excel.The course presents an easy and fastest way to build models in Excel. It covers the following topics: simple models, advanced models, regression analysis, seasonality, ARIMA models. Inside of the course you can find explanation of all Excel function which is used for models, so it requires just very basic Excel skills.

Who this course is for
For students and practitioners who require practical forecasting skills