Statistics Corner: Data Cleaning-II

JOURNAL TITLE: Journal of Postgraduate Medicine, Education and Research

Author
ISSN
2277-8969
DOI
10.5005/jp-journals-10028-1339
Volume
53
Issue
4
Publishing Year
2019
Pages
3
Author Affiliations
Article keywords

Abstract

Reality check Microsoft Excel is one of the most routinely used spreadsheets to enter and clean data by researchers. However, the lack of professional training in Excel hinder its efficient usage. Majority of investigators are aware of basic data entry and cleaning mechanisms in Excel. However, there are numerous advanced easy-to-use functions that increase the efficiency and accuracy of data entry. The present article will be discussing four vital functions to enter and clean data efficiently. These functions are the following: • Data form • Data validation • Go to special • Protecting specific columns, worksheet, and workbook

© 2019 Jaypee Brothers Medical Publishers (P) LTD.   |   All Rights Reserved

Powered by MPS ScholarStor