Time Series in Excel! Learn Exponential Smoothing Models for Time Series Forecasting in Excel

Overview

• Excel is the perfect fit for building your time series forecasting models
• We’ll discuss exponential smoothing models for time series forecasting, including the math behind them
• We’ll also implement these exponential smoothing models in MS Excel

 

Introduction

Time series in Excel – just seems like a natural fit, right? We see and design line charts in Excel all the time – from sales forecasts to revenue reviews – it all fits into how we think about using Excel in analytics and data science.

But here’s the thing about time series forecasting – it can appear daunting for beginners. It’s not a walk in the park. We need to understand how to deal with the time component and not just the other variables. And that time component can so often mess up our entire analysis!

While most courses and tutorials will show you how to perform time series forecasting in Python and R, this article has no such expectations. All you need is a working knowledge of Excel – and you’ll be able to follow along nicely!

To finish reading, please visit source site