A few solutions are proposed to perform a convolution in Excel in a non-manual way:

- The following formula is proposed conv(x,y) = ifft(fft(zeropad(x,length(x)+length(y)-1)) * fft(zeropad(y,length(x)+length(y)-1))).
- In this formula, *represents the point-wise multiplication of complex vectors.

- An Add-Inn named can be installed in Excel.
- It features a Fourier Transform Program that might be used to produce similar results.

- An Excel function called Convol(f, g, h, [algo]) can be used to approximate the convolution of two sampled functions.

- Convolution and deconvolution macros can be used to perform this task.

- Convolutions can be better performed using professional mathematical programs such as Matematica or Matlab.

You need to be the project owner to select a next step.