Enter your data in one column
Decide the class intervals or bins
List the bin values in a separate column
Use the FREQUENCY function
Select the output range for the frequency counts
Type `=FREQUENCY(data_range, bins_range)`
Press `Ctrl + Shift + Enter` in older Excel versions
Press `Enter` in newer Excel versions
Use the COUNTIF function for manual frequency tables
Create a PivotTable if you want a quick frequency summary
Insert a PivotTable from your data
Drag the field into Rows
Drag the same field into Values
Group the data if needed
Format the table as needed