Use Excel's built-in statistical functions and custom expressions ... Calculate your T-Value by taking the difference between the mean and population mean and dividing it over the standard ...

However, not every mean is an average because there are different kinds of means ... it’s time to introduce Excel’s TRIMMEAN() function, which removes a designated percentage of the largest ...