
Leveraging the Power of Excel for Your Program’s Data & Reporting Needs
Smriti Bajracharya, MPH, Project Coordinator
Center for Public Health Systems Science & Brown School Evaluation Center
Missy Krauss, MPH, Senior Data Analyst
Brown School Evaluation Center
Meihsi Chiang, MSW, Evaluation Associate
Brown School Evaluation Center
Learn how to utilize Microsoft Excel for organizing, analyzing, and reporting program data – beyond simple formulas and charts. The workshop is designed for people familiar with the most basic functions of Excel but inexperienced with its advanced features. We will discuss when Excel is appropriate as a data management and reporting tool, best practices for use, and how to take full advantage of features, such as data validation, conditional formatting, VLookup, pivot tables, and graphics.
The workshop will begin with a brief overview of Excel basics and end with a brief demonstration of more advanced functions, such as macros and dashboard reports, and will provide resources for further learning.
This is a hands-on workshop, using laptops equipped with Excel 2016.
Learn more and register (link to Brown School Professional Development)