Survey Data Analysis & Visualization

I have an Excel project involving data from a survey I conducted. The data consists of open-ended text responses that need to be categorized based on specific categories I have in mind. Once categorized, I need the data to be converted into numerical form and represented in various pie charts.

Ideal Skills:
- Proficient in Excel
- Data analysis
- Data visualization
- Categorization of qualitative data

Experience:
- Prior work with survey data
- Creating visual representations of data
- Working with Excel at an advanced level

Your task will be to help me make sense of my survey data and present it in a visually appealing way.