Excel can be utilized for many reasons, from making budgets for multinational corporations to maintaining track of enrollment dates for insurance company. Using Excel to build these difficult spreadsheets does not have to be hard, but it's vital to know how to sort and analyze data.

Instructions

Step 1

Start Excel. Make new spreadsheet and provide it explanatory name like "Enrollment Dates." Save spreadsheet.

Step 2

Generate column like Enrollee name, birth date and staffing date.

Step 3

Enter data for every enrollee on individual line or row. Ensure that you enter all data for every enrollee.

Step 4

Click "Tools" and select "Sort" after all data has been entered. Ensure "Header Row" choice is checked.

Step 5

Select column that has enrollment dates and sort by column. E.g., if enrollment dates are added in column C, sort by it. Tick "OK" to finish sort.