Consolidating survey results excel
Excel definition: software program by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions.
Excel analysis is ubiquitous around the world and used by businesses of all sizes to perform financial analysis.
Responses Data exports organize survey results in a spreadsheet where each row contains the answers from a given respondent.
The question type determines how the data is reported in the spreadsheet.
There are many reasons a financial analyst may want to use the Excel consolidate function.
One example would be combining budgets from various departments into one company-wide budget.
We outline the salary, skills, personality, and training you need for FP&A jobs and a successful finance career.
This setting only affects questions with a single answer choice allowed. This means instead of listing each answer option in separate columns, only the answer the respondent chose is listed in the cell—all responses are listed in one column.
If you choose to expand columns, every possible answer choice for a given question is listed in its own column.
Columns for custom 2-6 aren't shown unless you're using them. Blank cells are answer options the respondent didn't select or questions the respondent didn't answer or skipped due to logic in your survey design.
Questions with multiple rows, columns, or fields of answer choices span across multiple columns in the spreadsheet with each row, column, or field in its own column.
The key is to use labels carefully and ensure they are the same in each table (e.g., if you have a spelling mistake or slightly different version of the label, it will treat them as separate).