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.
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...
