Optimize Reporting with Excel: Data Models and Dashboards

September 19, 2025
1:00 pm - 4:00 pm
Brown School, One Brookings Drive, St. Louis, Missouri 63130
Optimize Reporting with Excel: Data Models and Dashboards. Presented by the Evaluation Center. Register at Brown School Professional Development

Learn advanced Excel techniques to build databases and create insightful reports—beyond basic spreadsheets.

Schedule

Friday, September 19, 2025

1:00 pm – 4:00 pm, Online

Workshop Description

Designed for professionals seeking to advance their expertise, this course covers the essentials of data modeling, transformation, and dashboard creation using Microsoft Excel.

Ideal for individuals in non-profits, government agencies, foundations, academic institutions, and other data-driven fields, this course focuses on leveraging Excel to measure outcomes and support strategic decision-making effectively.

Participants will explore best practices for using Excel, including determining when it is the appropriate tool and how to leverage features like Data Model, PowerPivot, Power Query, PivotTables, Slicers, and PivotCharts. Additionally, participants will learn to design and build dashboards tailored for different audiences and scenarios.

The instructors bring extensive expertise in program evaluation, the course incorporates real-world data examples, scenarios, and case studies to provide a practical learning experience. 

Instructors

Meihsi Chiang, MSW

Meihsi Chiang, MSW

Assistant Director (she/her/hers)

Is This Program for Me?

Excel users with basic skills who want to become more proficient in data exploration, analytics, and data visualization.

Individuals work in program evaluation, public health, non-profits, social service agencies, or academic institutions, seeking practical tools to streamline data analysis workflows and improve reporting.

For learners new to Excel, we recommend completed our introductory Excel workshop: Leverage the Power of Excel for Basic Data Management and Analysis before enrolling this advanced-level workshop.

Learn More & Apply

Learn more and register online through Brown School Professional Development.

Course Fee(s)

General Admission: $65*

*Discounts on workshop admission are offered to the Brown School’s students, alumni, and field instructors.

Continuing Education Information:

3 social work CEs in Missouri and Illinois