Cleaning Data, or More Neat Excel Tricks to Make it Easier
| Metadata Field | Value | Language |
|---|---|---|
| dc.contributor | Barbara Bishop, bishoba@auburn.edu | en_US |
| dc.creator | Bishop, Barbara A. | |
| dc.date.accessioned | 2017-10-27T13:45:18Z | |
| dc.date.available | 2017-10-27T13:45:18Z | |
| dc.date.created | 2017-11-08 | |
| dc.identifier.uri | http://hdl.handle.net/11200/49046 | |
| dc.description.abstract | 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. 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. | en_US |
| dc.format | en_US | |
| dc.relation.ispartof | Charleston Conference: Issues in Book and Serial Acquisition | en_US |
| dc.subject | Excel, Data Cleaning | en_US |
| dc.title | Cleaning Data, or More Neat Excel Tricks to Make it Easier | en_US |
| dc.type | Image | en_US |
| dc.type.genre | Presentation, Poster Presentation | en_US |
| dc.location | Charleston, SC | en_US |