Excel Categorical Analysis: Safety Concerns

I require expertise in creating an Excel framework that intelligently links drop-down menu selections to classify categorical observations, in this case, centered around safety concerns.

Key Tasks:
- Set up a dynamic Excel spreadsheet for data input and analysis
- Link drop-down menus to classify various safety-related categories
- Analyze data and visualize through coherent charts and graphs

Ideal Skills and Experience:
- Excel proficiency including data categorization and graphing
- Knowledge of safety standards and protocols to accurately classify categories
- Experience in handling and processing safety-related data.