Project Overview
A practical Excel-based solution automating inventory monitoring, reorder filtering, conditional formatting, KPI insights, PDF generation, and email dispatch. This project simplifies stock management using macros and interactive dashboards.
Key Features
📊 Interactive Dashboard with Pivot Charts & Slicers
⚙️ Reusable Macro Automation (.bas export)
📥 Merge Excel files (2023 & 2024) into one Reorder sheet
📤 PDF Export of reorder list
📧 Automated Email via Outlook
📌 Navigation Panel with Macro Buttons
Tools Used
Microsoft Excel (2016+)
VBA (Visual Basic for Applications)
Outlook (for email automation)
GitHub (project hosting)
Key Insights
Identified 595 reorder items out of 2,000 inventory lines
Top suppliers requiring reorder:
Gulf Coast Traders (221)
Coastal Logistics Partners (212)
Category with most reorder needs: Printer & Cleaning
Screenshots & Visuals
📷 Final Dashboard Image
📄 Sample PDF
🔁 Macro Button Panel
GitHub Repository
🔗 View on GitHub
Includes:
README.md
ApplyReorderLogic.bas: A reusable macro module so others can import it into their workbooks
Inventory_Dashboard_2023_2024.xlsx: Final Excel file with merged data, dashboard, slicers, charts, and tested macros
Reorder_Sample.pdf: Export sample of Filtered Reorder sheet
screenshots/dashboard_preview.png
What I Learned
Building end-to-end Excel automation with clean macros
Using pivot charts and slicers for interactive insights
Email integration with Outlook via VBA
Dashboard design principles for business reporting
What’s Next?
Web-based Streamlit version
Dynamic Power BI or Tableau dashboards
Multi-year trend analytics from warehouse data
📩 Have a similar challenge or project in mind?
I'm open to freelance opportunities, remote collaborations, or showcasing how I can help automate your Excel workflows and data processes.
📬 Get in touch:
📧 Email: dataexplorerconnects@gmail.com
💼 LinkedIn: Click here...
💻 GitHub: Click here..
🧠 Let’s turn your data into decisions.
Excel Dashboard Screenshot