Interpolating missing time series in Excel

In this video, we demonstrate the application of the Interpolate function in NumXL in finding value for a missing intermediate observation in an evenly spaced time series.

For our demo purposes, we used four different interpolation methods: forward flat, backward flat, linear and cubic spline.


Have more questions? Submit a request