Excel Analysis & Dashboard Creation - Purchase and Sale
Budget: ₹400 – ₹750 INR
I have a comprehensive Excel file containing purchase and sale details that needs thorough analysis and a dashboard built in a corporate visual style.
Key Requirements:
- Dashboard: It should display stock quantity, total amount, and total quantity, broken down by brand, type, and color.
- Stock Analysis: I need to see overall stock quantities by brand, type, and color, as well as date-wise tracking to see if a specific product is sold from a purchase date using FIFO method.
- Purchase Details: Total quantity and amount of purchases should be calculated, alongside a slicer to view specific combinations of brand, type, and color. A macro to add new entries is also required.
- Sale Insights: Total quantity and amount of sales, with a slicer for specific combinations, a macro for new entries, and a profit & loss calculation per sale entry.
The Excel files are compatible with Excel 2021. I'm looking for visualizations primarily using charts, graphs and tables, all adhering to a corporate style.
Ideal skills for this project include:
- Advanced Excel proficiency, particularly with data analysis and dashboard creation.
- Experience creating corporate-style visual content.
- Knowledge of macros and slicers in Excel.
Key Requirements:
- Dashboard: It should display stock quantity, total amount, and total quantity, broken down by brand, type, and color.
- Stock Analysis: I need to see overall stock quantities by brand, type, and color, as well as date-wise tracking to see if a specific product is sold from a purchase date using FIFO method.
- Purchase Details: Total quantity and amount of purchases should be calculated, alongside a slicer to view specific combinations of brand, type, and color. A macro to add new entries is also required.
- Sale Insights: Total quantity and amount of sales, with a slicer for specific combinations, a macro for new entries, and a profit & loss calculation per sale entry.
The Excel files are compatible with Excel 2021. I'm looking for visualizations primarily using charts, graphs and tables, all adhering to a corporate style.
Ideal skills for this project include:
- Advanced Excel proficiency, particularly with data analysis and dashboard creation.
- Experience creating corporate-style visual content.
- Knowledge of macros and slicers in Excel.