Libraries Workshop: Preparing Your Data with Excel

DateMarch 27, 2020Time3:30 - 5:00 pm
LocationG42 classroom, Moody Memorial Library
DescriptionData 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; convert 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
PublisherUniversity Libraries
vCalDownload this event