Public Economic Data Excel Dashboard
Budget: $30 – $250 USD
I am looking for someone to finish building a polished, self-contained Excel dashboard using freely available government data.
Project Scope
I need an Excel expert who can take publicly accessible datasets and turn them into a clean, interactive dashboard that demonstrates strong skills with:
Pivot tables
Pivot charts
Named ranges
Slicers
Conditional formatting
Other interactive Excel features
What I need you to complete:
• Identify reliable public datasets (e.g., Bureau of Labor Statistics, FRED, World Bank, or other government sources).
• Import, clean, and organize the data in Excel, using structured tables and named ranges so refresh works smoothly.
• Create a backend worksheet containing all pivot tables and calculations.
• Build a professional dashboard sheet that links to the pivots and includes charts and slicers for easy filtering and exploration.
• Document all data sources and provide either screenshots or a short walkthrough video demonstrating how the dashboard works.
Requirements:
The final Excel file must open without add-ins and maintain all formatting when shared.
Everything must refresh cleanly and remain self-contained within the file.
If this is something you can complete, please reach out with examples of similar Excel dashboards you’ve built.
Project Scope
I need an Excel expert who can take publicly accessible datasets and turn them into a clean, interactive dashboard that demonstrates strong skills with:
Pivot tables
Pivot charts
Named ranges
Slicers
Conditional formatting
Other interactive Excel features
What I need you to complete:
• Identify reliable public datasets (e.g., Bureau of Labor Statistics, FRED, World Bank, or other government sources).
• Import, clean, and organize the data in Excel, using structured tables and named ranges so refresh works smoothly.
• Create a backend worksheet containing all pivot tables and calculations.
• Build a professional dashboard sheet that links to the pivots and includes charts and slicers for easy filtering and exploration.
• Document all data sources and provide either screenshots or a short walkthrough video demonstrating how the dashboard works.
Requirements:
The final Excel file must open without add-ins and maintain all formatting when shared.
Everything must refresh cleanly and remain self-contained within the file.
If this is something you can complete, please reach out with examples of similar Excel dashboards you’ve built.