Excel Dashboard Development

I'm seeking an Excel expert to develop a comprehensive dashboard.

Key Requirements:
- Connect the dashboard to various CSV files
- Utilize Pivot tables and VLOOKUP for data analysis
- Create an interactive and user-friendly dashboard

Ideal Skills:
- Extensive experience with Excel, particularly in creating dashboards
- Proficient in using Pivot tables and VLOOKUP
- Ability to make the dashboard visually appealing and easy to understand

Tasks:

1. Create a Summary Table (using Pivot Tables):

* Generate a pivot table to summarize data:
* Example Summaries:
* Average frequency of social media platform usage (facebook_granu_freq, linkedin_gran_freq, etc.).
* Average trust levels in news (news_trust_1, news_trust_2, etc.).
* Grouping by region or gender for breakdowns.
* Include slicers for dynamic filtering by gender, region, or other categorical variables.

2. Add Dynamic Charts:

* Create charts based on the pivot table:
* A bar chart comparing average social media usage.
* A line chart to visualize trends across categories like regions.
* Use slicers to make the charts interactive.

3. Incorporate a Search Tool with VLOOKUP or FILTER:

* Allow users to search for a respondent by ID and display their data.
* Create a separate "Search" sheet:
* Add a search box for entering the ID.
* Use VLOOKUP or XLOOKUP to pull all relevant data for the entered ID.

If you can help with this project, please get in touch.