Before:
Raw transaction data — inconsistent client names, random formatting, no clear structure. Took forever to make sense of, let alone present.
After:
Clean, structured, color-coded sheet — proper headers, sorted by region & department, payment methods standardized, profit...
Built an interactive Annual Sales & Expense Tracker dashboard in Excel — tracks daily sales, cash vs NETS breakdown, and 5 expense categories across 12 monthly sheets. Includes auto-calculated KPIs and visual summaries for quick decision-making.
This project shows how I handle high-volume data entry for product catalogs — not just typing data in, but building accuracy checks into the sheet as I go.
What I did:
Entered 1,000+ product records across category, unit, quantity, and price fields
Set up dropdown lists for...
