Excel Sales Data Interrogation Tool
Budget: $250 – $750 AUD
I need an Excel spreadsheet to analyze sales data from a report in xls or csv format. The goal is to track sales of individual items daily and calculate average sales for each day of the week with minimal manual input.
Requirements:
- Upload sales data automatically from a file (xls or csv)
- Record the following metrics:
- Sales by individual item
- Average daily sales by day of the week
- Include these data points in the report:
- Item name
- Quantity sold
- Total sales amount
Ideal skills and experience:
- Proficiency in Excel, particularly in data analysis and automation
- Experience with creating automated data import setups
- Attention to detail to ensure accurate data representation
Requirements:
- Upload sales data automatically from a file (xls or csv)
- Record the following metrics:
- Sales by individual item
- Average daily sales by day of the week
- Include these data points in the report:
- Item name
- Quantity sold
- Total sales amount
Ideal skills and experience:
- Proficiency in Excel, particularly in data analysis and automation
- Experience with creating automated data import setups
- Attention to detail to ensure accurate data representation