Excel Workbook for Customer Insights
Budget: $30 – $250 CAD
I need an Excel workbook that incorporates customer contact information, sales volumes, and insightful visualizations for better decision-making.
Key Features Needed:
- **Customer Contact Information**: The workbook should include customer names 2 contact info fields (email & phone).
Data Representation:
- **Sales Data & Customer Slicing**: There should be 3 sheets within the workbook with sales volumes. Users should be able to use a pivot table to filter and slice data by branch and year.
- **Customer Variances Year-over-Year**: I need the workbook to show customer variances year-over-year. This should include both percentage change and absolute difference.
Visualization:
- **Top 10 Customers**: The workbook should contain an Excel table that presents the top 10 customers by volume.
Ideal Skills:
- Proficiency in Excel, especially in pivot tables and data visualization
- Experience in creating dynamic and interactive spreadsheets
- Understanding of customer variance analytics
Please make sure that the workbook is user-friendly, and the layout is intuitive for ease of use.
Key Features Needed:
- **Customer Contact Information**: The workbook should include customer names 2 contact info fields (email & phone).
Data Representation:
- **Sales Data & Customer Slicing**: There should be 3 sheets within the workbook with sales volumes. Users should be able to use a pivot table to filter and slice data by branch and year.
- **Customer Variances Year-over-Year**: I need the workbook to show customer variances year-over-year. This should include both percentage change and absolute difference.
Visualization:
- **Top 10 Customers**: The workbook should contain an Excel table that presents the top 10 customers by volume.
Ideal Skills:
- Proficiency in Excel, especially in pivot tables and data visualization
- Experience in creating dynamic and interactive spreadsheets
- Understanding of customer variance analytics
Please make sure that the workbook is user-friendly, and the layout is intuitive for ease of use.