Practical Forecasting with Excel

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.