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

  1. import text into excel
  2. export a csv file from excel
  3. covert text into columns
  4. split data from one column to two columns
  5. concatenate data from two columns into one column
  6. perform global find and replace
  7. understand how dates are stored in excel
  8. rename a batch of files
Date:
Friday, April 24, 2020
Time:
3:30pm - 5:00pm
Location:
Moody G42
Categories:
  Digital Scholarship Workshops     Science Research Workshops  

Event Organizer

Profile photo of Christina Chan-Park
Christina Chan-Park