Skip to main content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

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 GitHub. The dataset is a small subset of the 2018 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