Dynamic Excel Sales Dashboard Creation
Budget: €8 – €30 EUR
I have an Excel file with multiple tabs, each representing a month of the year. Within each tab, my products are listed in one column, and the days of the month are represented in rows. The cells that intersect contain a number representing the quantity of products sold on the corresponding day.
I need a new dynamic tab created that has at least two columns: one for products that have sold at least one unit, and another for the total number of items sold. Products that have no sales on a given day should not be displayed.
This new tab should be dynamic, allowing me to see which products have sold on a given day. There should be a day selector that filters the products accordingly.
Specific Requirements:
- The new tab should be formatted as a simple table
- The project is in Excel 2016 or earlier
- The day selector should use a calendar input
Ideal skills and experience for the job:
- Proficient in Excel with experience in creating dynamic tabs and using data validation rules
- Attention to detail to ensure accuracy in sales data
- Ability to create clear and simple layouts for easy navigation
I need a new dynamic tab created that has at least two columns: one for products that have sold at least one unit, and another for the total number of items sold. Products that have no sales on a given day should not be displayed.
This new tab should be dynamic, allowing me to see which products have sold on a given day. There should be a day selector that filters the products accordingly.
Specific Requirements:
- The new tab should be formatted as a simple table
- The project is in Excel 2016 or earlier
- The day selector should use a calendar input
Ideal skills and experience for the job:
- Proficient in Excel with experience in creating dynamic tabs and using data validation rules
- Attention to detail to ensure accuracy in sales data
- Ability to create clear and simple layouts for easy navigation