REDCap Data Quality and Reports

Wednesday, June 22, 2022, 10:00am to 11:00am

Data Handling covers the basic "must know" items for transforming your data using Excel and Sublime. Basic understanding of Excel is recommended prior to taking this course.

Excel Topics Covered

  • Bringing Data into Excel
  • Making it easier to view & understand your data
  • Categorizing raw data
  • Creating a basic calculation
  • Vlookup
  • Totals
  • Tables
  • Pivot tables

Sublime Topics Covered

  • Finding data
  • Editing multiple rows of data at once
  • Cleaning Data
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 Joe Spring in advance at 319-353-6229 or