Justin Bauzon, Caleb Murphy and Sandhya Wahi-Gururaj (all Medicine) recently published "Using Macros in Microsoft Excel to Facilitate Cleaning of Research Data" in the Journal of Community Hospital Internal Medicine Perspectives.
Retrospective chart review studies may be delayed by inability to export clean clinical data from an electronic medical record or data repository. Macros are pre-programmed procedures that can be used in Microsoft Excel to help streamline the process of cleaning clinical datasets.
