Financial Data Dashboard Creation in Excel or online
Budget: $30 – $250 AUD
I'm looking for an Excel expert to build a comprehensive financial dashboard for me. The dashboard should be able to pull data from a structured folder containing 12 monthly Excel files and one budget file. All these files have the same data output page.
Key Requirements:
- The dashboard should allow me to select a month. For instance, at the end of March, I should be able to view:
- Actuals for March from the March file
- Forecast for March from the February file
- March's budget from the Budget file
- The dashboard needs to display various types of financial data including:
- Revenue and expenses
- Profit and loss
- Cash flow
- Data visualization is an important aspect of this project. The dashboard should include charts and tables to represent the financial data clearly and effectively.
Ideal Skills and Experience:
- Extensive knowledge and experience in Excel
- Proven track record of creating financial dashboards
- Excellent data visualization skills
- Strong understanding of financial data
- Able to work with structured data sets.
Key Requirements:
- The dashboard should allow me to select a month. For instance, at the end of March, I should be able to view:
- Actuals for March from the March file
- Forecast for March from the February file
- March's budget from the Budget file
- The dashboard needs to display various types of financial data including:
- Revenue and expenses
- Profit and loss
- Cash flow
- Data visualization is an important aspect of this project. The dashboard should include charts and tables to represent the financial data clearly and effectively.
Ideal Skills and Experience:
- Extensive knowledge and experience in Excel
- Proven track record of creating financial dashboards
- Excellent data visualization skills
- Strong understanding of financial data
- Able to work with structured data sets.