Skip to Main Content

Data Cleaning with Excel

Through this guide you will learn tricks and tips to better clean and organize tabular data using Microsoft Excel.

Introduction

The data cleaning exercises demonstrated in this guide reference and are taken from the Galter Health Sciences Library & Learning Center class 10 Simple Rules for Data Cleaning with Excel. The dataset used in that class can be accessed from Google Drive. The dataset is a small subset of the 2022 National Electronic Injury Surveillance System dataset, available at: https://www.cpsc.gov/cgibin/NEISSQuery/home.aspx

References:

1. US Consumer Product Safety Commission. NEISS Highlights, Data and Query Builder. Available at: https://www.cpsc.gov/cgibin/NEISSQuery/home.aspx