Back To Schedule
Wednesday, November 8 • 6:00pm - 6:45pm
06 Cleaning Data, or More Neat Excel Tricks to make it Easier

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Librarians deal with data from a variety of sources and each source can be unique in how it presents in Excel. Cleaning data is inevitable and some of worst is patron supplied data. Here are some basic and not so basic tips and tricks to deal with disappearing leading zeros, consistency in case, trimming those fields, tables for all, and how pivot tables can be your friend.

avatar for Barbara Bishop

Barbara Bishop

Librarian for Communication, Journalism & Theatre, Auburn University Libraries

Wednesday November 8, 2017 6:00pm - 6:45pm EST
Carolina Ballroom, Francis Marion Hotel 387 King Street, Charleston, SC 29401