Use the formula `=(A1-AVERAGE($A$1:$A$10))/STDEV.S($A$1:$A$10)` for a sample z score
Use the formula `=(A1-AVERAGE($A$1:$A$10))/STDEV.P($A$1:$A$10)` for a population z score
Replace `A1` with the cell containing the value you want to standardize
Replace `A1:A10` with the range containing your data
Press Enter to calculate the z score
Copy the formula down to find z scores for other values in the same dataset