Logo for University of Iowa Health Care This logo represents the University of Iowa Health Care

REDCap Data Quality and Reports

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 joseph-spring@uiowa.edu