Designing Interactive Data Dashboards with Excel: Beginner Level

EASL is glad to welcome Tom Withee and Shelly Engelman for another round of this popular 2-part series previously hosted in December 2020!

Interactive Data Dashboards with Excel: Beginner Level

Cost: $100 for EASL Members / $175 for General Public

Creating dynamic dashboards in Excel is a fantastic and cost-effective way to view important data with minimal construction time. This workshop takes you through all you need to know to design interactive dashboards from start to finish in Excel. Shelly and Tom will provide you with practical, hands-on, step-by-step instructions to turn your static data table into a dynamic dashboard that will “wow” your stakeholders. We will demonstrate how to use Pivot Tables, PivotCharts, and Slicers to create well-designed dashboards that allow your stakeholders to slice-and-dice the data in seconds. You will leave the workshop with clear steps that you can immediately implement to create stunning dashboards that are pliable, dynamic and easy to reproduce.

You will learn:

• How to use PivotTables, PivotCharts, and Slicers to create interactive dashboards

• Quick visualization tips and tricks to customize your dashboards for stakeholders

• How to secure your dashboard using built-in protection features

• Different chart types to display data in the most meaningful way

Prerequisites:

• Basic knowledge of Excel (e.g., charts, basic formulas)

• PivotTable knowledge is helpful, but not necessary to take this workshop

Presenters:
Tom Withee has over 20 years’ experience as an educator, education researcher and adjunct faculty and is currently a senior researcher for Goshen Consulting. At Goshen, he continues to support STEM education through program evaluation and working with agencies to elevate all educators. Tom brings his data analysis and visualization skills as well as deep insight in education to all projects he is involved in. He continues to develop through active involvement in the American Evaluation Association.

Shelly Engelman, Ph.D., is the Director of Research and Evaluation at Custom EduEval LLC in Austin, TX. She earned her PhD in Social Psychology and has over 10 years of research and evaluation experience. Dr. Engelman has been a lead data analyst and behavior science methodologist on over 40 federal and state funded grants and programs. She has a strong knowledge of evaluation and research methodology and theory, as well as an expertise in survey design and advanced statistical modeling techniques (e.g., Structural Equation Modeling, Propensity Score Matching, etc.). Dr. Engelman has led over 20 workshops, seminars, and demonstrations for a variety of clients including, Centers for Disease Control and Prevention (CDC), Governor’s Office of Student Achievement (GOSA), and the University of Texas at Austin (UT Austin). Prior to working as an evaluation and research consultant, Dr. Engelman taught an array of undergraduate courses at the University of Delaware, such as Research Methods, Statistics, and Social Psychology.