Do you have data that is not ready for analysis? Are you unsure what all you need to do with “dirty” data? In this workshop, we will go through what data cleaning means, what you should know in preparation for data cleaning, and best practices before working with a provided dataset in Excel to fix common issues found in “dirty” data. We will also discuss common ways to modify the structure of variables to meet analytic needs. If time allows, we will talk about managing identifiers and adding data points.
This workshop is a combination of interactive lecture and hands-on work in Excel with a tabular dataset. Focus is on general data principles, with some specific information related to human subjects, quantitative, and qualitative data. Registration is required, and space is limited. Registration link: https://go.unl.edu/applieddatacleaning
Learning objectives
- Increased awareness of different data issues and how to address them
- Ability to manipulate data for greater analytic utility
- Greater familiarity with Excel
- Tips and tricks that make your adventures with data easier
Date: August 7, 2026
Time: 9:30 AM - 3:00 PM
Location: Oldfather Hall Room 738
Contact: Alian Kasabian (aliank@unl.edu)
Prerequisites
Participants are expected to have some familiarity with Excel, such as the ability to use formulas and make tables. Knowledge of pivot tables is a bonus, but will also be demonstrated.
Optional micro-credential credit
This workshop counts 5 credits towards the optional Research Data Life Cycle Micro-credential. Sign in for credit will be at end of workshop. Learn more about the Micro-credential here: https://go.unl.edu/ddlc_microcredential
More details at: https://events.unl.edu/RDWeb/2026/08/07/200863/