How to use the FORECAST.ETS Function in Microsoft Excel - Part I

The FORECAST.ETS Function in Excel uses an exponential smoothing algorithm to predict a future value on a timeline, based on a series of existing values.
When you use a formula to create a forecast, it returns a table with the historical and predicted data, and a chart. The forecast predicts future values using your existing time-based data and the AAA version of the Exponential Smoothing (ETS) algorithm.
This video focuses on the first part on how to prepare your forecast data and to pick inputs for the FORECAST.ETS Function