This is the sixth and final step in the REDCap training series. In this training we won't use REDCap at all. Instead, we will cover ways to view and manage your exported REDCap data in Microsoft Excel and Sublime Text such as:

Populating data from one Excel sheet to another with vlookup()

Seeing specific data with column sorting and filtering

Ensuring data is cohesive by creating tables

Looking at how data relates to other data by creating pivot tables

Transforming unusable data to a usable format...

Ben Kreitlow is a PhD candidate in the Neuroscience Interdisciplinary Graduate Program, as well as a student in the Medical Scientist Training Program (MSTP). His research has been conducted in Dr. Gordon Buchanan's laboratory.

If you are unable to attend in person, please consider showing your support and attending via Zoom. Please email britt-hokanson@uiowa.edu for the zoom link.