Using macros in microsoft excel to facilitate cleaning of research data
Background: Retrospective chart review studies may be delayed by inability to export clean clinical data from an electronic medical record (EMR) or data repository. Macros are pre-programmed procedures that can be used in Microsoft Excel to help streamline the process of cleaning clinical datasets....
Main Authors: | Justin Bauzon, Caleb Murphy, Sandhya Wahi-Gururaj |
---|---|
Format: | Article |
Language: | English |
Published: |
Greater Baltimore Medical Center
2021-09-01
|
Series: | Journal of Community Hospital Internal Medicine Perspectives |
Subjects: | |
Online Access: | http://dx.doi.org/10.1080/20009666.2021.1954282 |
Similar Items
-
Optimal Production Scheduling using VBA on Microsoft Excel
by: Pornrat Thumrongvut
Published: (2019-02-01) -
Developing the Students’ Ability in Understanding Mathematics and Self-confidence with VBA for Excel
by: Martin Bernard, et al.
Published: (2019-01-01) -
Tutorial Review: Simulation of Oscillating Chemical Reactions Using Microsoft Excel Macros
by: Abdolhossein Naseri, et al.
Published: (2016-12-01) -
Microsoft Excel 2000 /
by: 317332 Hutchinson, Sarah E., et al.
Published: (2000) -
QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures
by: K. Thomas Klasson
Published: (2018-06-01)