Title Normalization & Quality Control: Making Excel Work for You and Not the Other Way Around
| dc.contributor.advisor | Goldfinger, Rebecca | |
| dc.contributor.author | Burt, Claralyn | |
| dc.date.accessioned | 2019-06-13T16:27:05Z | |
| dc.date.available | 2019-06-13T16:27:05Z | |
| dc.date.issued | 2019-06-11 | |
| dc.description | Every year, the Continuing Resources & Database Management Division systematically renews the journal and serial subscriptions for the Library.There are many moving parts resulting in a multi-step, multi-month workflow. This past 2018 renewal season, I streamlined the process in two innovative ways: title normalization and using the IF function in Excel as a quality control step. I began by cleaning the data to normalize the titles. After completing a rigorous vLookUp function, I added a quality control step with an IF function to ensure that the matches were accurate. Because I took the time to standardize and normalize my data at the beginning of this process, I could create a better, more inclusive formula. Ultimately, I did not have to manually check hundreds of titles because I engineered Excel to do it for me. This saved time and money in meeting the needs of the users and researchers here at McKeldin Library. | en_US |
| dc.description.abstract | Every year, the Continuing Resources & Database Management Division systematically renews the journal and serial subscriptions for the Library.There are many moving parts resulting in a multi-step, multi-month workflow. This past 2018 renewal season, I streamlined the process in two innovative ways: title normalization and using the IF function in Excel as a quality control step. I began by cleaning the data to normalize the titles. After completing a rigorous vLookUp function, I added a quality control step with an IF function to ensure that the matches were accurate. Because I took the time to standardize and normalize my data at the beginning of this process, I could create a better, more inclusive formula. Ultimately, I did not have to manually check hundreds of titles because I engineered Excel to do it for me. This saved time and money in meeting the needs of the users and researchers here at McKeldin Library. | en_US |
| dc.identifier | https://doi.org/10.13016/9mvf-i0q7 | |
| dc.identifier.uri | http://hdl.handle.net/1903/21855 | |
| dc.language.iso | en_US | en_US |
| dc.relation.isAvailableAt | Library Research & Innovative Practice Forum | |
| dc.relation.isAvailableAt | Digital Repository at the University of Maryland | |
| dc.relation.isAvailableAt | University of Maryland (College Park, Md) | |
| dc.subject | Microsoft Excel, Functions, Formulas, Title normalization, Quality Control | en_US |
| dc.title | Title Normalization & Quality Control: Making Excel Work for You and Not the Other Way Around | en_US |
| dc.type | Other | en_US |
Files
Original bundle
1 - 1 of 1
Loading...
- Name:
- 2019_LRIPF_Poster_Burt.pdf
- Size:
- 401.77 KB
- Format:
- Adobe Portable Document Format
- Description:
- Poster Presentation
License bundle
1 - 1 of 1
No Thumbnail Available
- Name:
- license.txt
- Size:
- 1.57 KB
- Format:
- Item-specific license agreed upon to submission
- Description: