Built an 8-sheet Excel financial reporting system for a residential property association, consolidating 1,000+ revenue and expense records into monthly reports,
dashboards, and budget allocation summaries.
Engineered a dynamic, formula-driven owner payment statement (INDEX/MATCH, COUNTIF array logic) that auto-generates individual transaction histories for
40+ property owners without VBA or Power Query.
Built two interactive dashboards with 10 charts controlled by a single year-filter, giving stakeholders real-time visibility into monthly revenue, expenses, and net
balance.