Event box

Preparing Your Data with Excel

Data can be messy and sometimes you need to prepare or clean-up your data before you can analyze it.

In this workshop, you will learn the basics of data prep using excel.

 

Participants will

  • import text into excel
  • export a csv file from excel
  • covert text into columns
  • split data from one column to two columns
  • concatenate data from two columns into one column
  • perform global find and replace
  • understand how dates are stored in excel
  • rename a batch of files
Date:
Wednesday, September 22, 2021
Time:
3:30pm - 5:00pm
Time Zone:
Central Time - US & Canada (change)
Location:
Jones 105
Categories:
  Digital Scholarship Workshops     Science Research Workshops     Social Science Workshops  
Registration has closed.

Event Organizer

Profile photo of Christina Chan-Park
Christina Chan-Park