Survey Results in Excel

[ColleenMarie47]

My organization conducts a survey of 75 companies and currently processes the results and generates the report using SQL. The process is about 20 years old and involves several different programs. It is incredibly complex and requires coding experience just to make any changes to the survey. My boss is asking me to find a way to generate the same report with Excel. Is this possible? Are there any resources that I can use to learn to do this?

 

[ColleenMarie47]

I should add that the survey is in Excel format and results are sent back to us. So in the end, I have 75 individual spreadsheets. I am looking for guidance on how to combine them and generate a report of the data.