Browse categories
Explore
Fiverr Pro
English
$
USD
I will design an automated e commerce sales tracker and profit loss dashboard in excel
About this Gig
Is your e-commerce sales data messy? Let me clean and visualize it for you!
I build custom, fully automated sales + profit + stock dashboards for online stores (Shopify, Amazon, WooCommerce, etc.) using Microsoft Excel, Power BI, and Looker Studio.
What you will get:
- Daily Sales Tracker: Easily log and monitor your daily revenue.
- Profit & Loss Calculator: Automatically see your net margins.
- Inventory Control: Built-in low stock alert system.
- Data Cleaning: Complete removal of errors, duplicates, and broken formatting.
- Visual Dashboard: Interactive view with 5+ charts, Pivot Tables, and slicers.
️ Advanced Tools & Formulas Used:
- Advanced Formulas (VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS),
- Conditional Formatting, Drop-down, Pivot Tables, Slicers, Charts, KPI Cards.
- Available in Excel Online and Google Sheets.
FREE SAMPLE: Want to see my work first? Send me a message and I will provide a free dashboard sample right away!
Your file will be 100% editable, secure, and delivered fast with unlimited revisions.
Programming language:
Other
Technology:
Excel
•
Google Data Studio
•
Google Sheets
Expertise:
Business Insights
•
Trends
•
Forecasting
•
Statistics
Tools:
Microsoft Excel
•
Other
My Portfolio
FAQ
Will you clean my messy data before creating the dashboard?
Yes, data cleaning is 100% free with this gig. Just send your Shopify / Amazon messy file, I will clean it and make the dashboard.
Can I see a free sample before ordering?
Yes! Just message me "FREE SAMPLE" and I will send you my Snitch clothing dashboard sample instantly so you can check quality.
Can you make this in Google Sheets or Power BI?
Yes, I can make the same sales + profit + inventory dashboard in Excel, Google Sheets and Power BI. Just tell me after ordering.
