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.

Open a new Microsoft Excel 2010 spreadsheet by double-clicking the Excel icon. Click on cell A1 and enter the first number in the set of numbers that you are investigating.