Conduct your survey
Hand out your survey questionnaires for others to complete, or interview people in person. After all of the questionnaires have been turned in, enter the data into a database in Office Excel 2007?
Create your database
This is your header row.
- Open a new workbook in Office Excel 2007.
- In row 1, type field names in each column that correspond to the survey questions.
- In the rows beneath the header row, type the answers from the questionnaires, so they line up with the proper field names in the header.
- Select all the cells in the database, and, on the Insert tab, click Table. Select My table has headers, and then click OK. Office Excel 2007 turns your data into a table. Now you can click the arrows in the header row to sort or filter the table.