How to Normalize in Excel. When dealing with mathematics, the process of normalization takes large number sets and reduces them to a smaller scale, helping you better compare different data sets.