If you are looking forward towards calculating the Standard Deviation and Standard Error of the Mean in Excel, please check this article.

Data Required for T-Value You can calculate the T-Value in Excel with the mean, standard deviation and degrees of freedom.