Transforming Student Data with Excel Automation

Presenter: Amy McFarland (Graduate Program Coordinator, Statistics & Biostatistics)

As graduate coordinators, we have access to a huge volume of student data, but this data is often formatted or siloed in a way that limits usefulness and usability. Utilizing Excel formulas and power query automation, disparate data sources can be integrated, organized, and streamlined into useful and usable data. Updating records can be as easy as copy and paste.

The presentation will include a tour of a fully customized, automated student tracking spreadsheet, and a demonstration of how to adapt a pre-made template spreadsheet for your program's needs.