How to create interactive dashboards in Excel

August 25, 2015
  • AACRAO Connect

Digital dashboards make it possible to create and maintain up-to-date, easy-to-understand, and graphically rich summaries for decision makers. 

No budget for specialized dashboard programs? Can’t keep up with end-user demands for different analyses?  New features in Excel 2010 and 2013 let even casual users to create interactive dashboards that are both functional and appealing—allowing you to convert your data into actionable information.

Dashboard software is providing colleges and universities better access to their data and greater insight into their key performance indicators (KPIs). Dashboards are being utilized to monitor Higher Education KPIs such as enrollment, accreditation, institutional research, and departmental metrics.

AACRAO will host a live, free webinar Tuesday, September 15, from 2:00-3:00pm ET, presented by Loralyn Taylor, Ph.D., Director of Analytics for University Students Success Initiatives, Ohio University; and Jennifer Chadwick, Associate Vice President for Enrollment Management, University of North Georgia.  In this webinar, you will learn the basic steps for creating interactive dashboards in Excel 2010 and 2013. Taking a holistic SEM approach, they will examine several use-cases throughout the student lifecycle.

Click here for more information and to register.

Subscribe

AACRAO's bi-weekly professional development e-newsletter is open to members and non-members alike.