Home

Calendar

Filter

Search

REDCap Data Handling

Apr 18, 2024

10:00 AM - 11:00 AM

Save to My Events

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 with text manipulation
• And more

This training is optionally hands-on so you can work on a sample data set along with the instructor or just watch. After this training, you will have a basic understanding of Excel and Sublime Text.

Register by clicking the virtual event link above or by going here:  https://redcap.link/icts_training

Individuals with disabilities are encouraged to attend all University of Iowa–sponsored events. If you are a person with a disability who requires a reasonable accommodation in order to participate in this program, please contact in advance at