SEM is the standard deviation of the sample-mean estimate of a population mean.
SEM is calculated by taking the standard deviation and dividing it by the square root of the sample size. In Excel, this is calculated using the following formula:
=stdev(range)/sqrt(count(range))