Executive car Workshop company dashboard
Budget: $30 – $250 USD
I need a skilled Excel expert to create a financial dashboard from an existing Excel sheet.
Requirements:
- Visualize financial data using charts and graphs
- Highlight key metrics: Total sales, Sales by product
- Ensure the dashboard is interactive and user-friendly
2. Productivity (Daily, Monthly, YTD)
3. Total Sales
4. Collections Summary
5. Job Orders Done vs. Pending and on hand
6. Sales by Company
7. Expenses per Car
8. On-Hand Cars Table
9. Gross Profit Calculation
10.Monthly Job Orders Received
Ideal Skills:
- Proficiency in Excel
- Experience with data visualization
- Strong analytical skills
- Attention to detail
Requirements:
- Visualize financial data using charts and graphs
- Highlight key metrics: Total sales, Sales by product
- Ensure the dashboard is interactive and user-friendly
2. Productivity (Daily, Monthly, YTD)
3. Total Sales
4. Collections Summary
5. Job Orders Done vs. Pending and on hand
6. Sales by Company
7. Expenses per Car
8. On-Hand Cars Table
9. Gross Profit Calculation
10.Monthly Job Orders Received
Ideal Skills:
- Proficiency in Excel
- Experience with data visualization
- Strong analytical skills
- Attention to detail