We need help summarizing results from surveys and reporting results. These surveys typically have 20-25 questions, and 100-200 responses.
We’d like someone to work with the data in Excel, creating a workbook that generates simple tables and charts for results for each question. Wed like this done in a way that allows for charts/table to auto-update if we adjust the original data. In the past, we’ve done this by staging the data in one worksheet, then building separate sheets, one for each question, for the various questions.
The results will be used by our designer to create charts and graphs, so they don’t require a high level of formatting. We will have one or two projects like this each month.