Hello! Can anyone help me how do I get the fourier transform (MS excel) of tidal data? I am given the hourly data, and height . I am confused how to exactly calculate for the frequency and amplitude. If you can give me a sample excel template as well.

Thank you!