Although I’ve been putting it off for months (years?), I finally made a guide on performing a one-sample t-test in Excel. The “Data Analysis” add-on in Excel is not able to calculate this statistic directly, so we have to trick Excel into calculating it for us. Nevertheless, the guide provides clear instructions on how to do so.
Here is a link to it: https://mattchoward.com/one-sample-t-test-in-excel/ .
Please email me at MHoward@SouthAlabama.edu if you have any questions!