Starting from:

£2.99

Exponential Smoothing

Here is my Office 365 LAMBDA Excel Formula that can be used to perform Exponential Smoothing on a range of values including the use of an Alpha value alongside the initial priming value. You can use this type of Function to create a 'smoothed' level as an input into a Forecast Model

A single Example of usage is provided alongside the Lambda test Formula.  The Function itself is called by passing, for example: =ExponentialSmoothing($D$28:$R$28, 0.4, $D$28) which includes in any Worksheet in Excel for a range of any size ($D$28:$R$28 are the actuals, 0.4 is the Alpha coefficient and $D$28 is the initial priming cell / first value)

You can view the Exponential Smoothing in action:

Exponential Smoothing