In the "Exit Interview" tab, you'll see a list of questions in Column A. These are the questions you'll ask the employee during the exit interview.

Column B is where you will record the employee’s responses. For each question, write down their answer in Column B next to the corresponding question.

For questions like "What is your primary reason for leaving the company?", you'll see a dropdown list in Column B. Select the appropriate reason from the list (e.g., Better career opportunity, Work-life balance).

For open-ended questions, type a detailed response directly into the "Response" field.

After you’ve filled out all the responses for the first interview, save the file with a new name (e.g., Exit Interview - Employee 1).

You can also choose to keep this as the first row and continue to add more interviews below.

In the next empty row below the first interview, begin entering the responses for the second exit interview.

Make sure to copy the questions from Column A and paste them into the next row for consistency.

Just like you did for the first interview, record the responses in Column B.

If any dropdowns are available (for example, for reasons for leaving), select the appropriate option.

For open-ended questions, type the employee’s answers into the "Response" column.

For each subsequent interview, follow the same steps as above. Add a new row, complete the responses, and continue this process until all exit interviews are filled out.

If you want to manually analyze responses after completing several interviews, go to Column B and review the answers for common themes.

For numeric or rating-based questions, you can manually calculate averages or summarize the data using simple Excel formulas, like =AVERAGE() or =COUNTIF().