Designing Duplicate Dashboards
Ama dedicates significant time to thinking creatively about how to present data. In this personal project, she envisioned how a national nonprofit might use Excel to capture and visualize its impact across ten fictional cities. The result is a clean, streamlined dashboard design.
Built entirely in Excel without VBA, the dashboard relies on a comprehensive codebook and five built-in features: (1) Data Validation, (2) IF statements, (3) VLOOKUP, (4) Data Bars, and (5) Wingdings (font). The outcome is a series of simple yet powerful automated dashboards that demonstrate how accessible tools can be leveraged for impactful data storytelling.