PDA Event: Excel for Library Projects Series: Learn by Doing: Project 3: Data Cleaning for Collection Analysis

Let’s learn methods to clean up data so that it’s easier to combine with other data. For this project, we’ll focus on Excel functions for cleaning and re-structuring data. We will then combine data from more than one data source. We’ll continue building on our skills with functions so that they perform more of our work for us, more quickly. We may look at other tools that work well with Excel.

Presenter: 

Nat Gustafson-Sundell is a Collections Librarian and Professor at Minnesota State University Mankato. Previously, he was an Electronic Resources Librarian at Northwestern University. In his first career, he served as Treasurer (CFO) of a software company and Business Manager of a market research firm. At Mankato, Nat is a College of Business liaison and he leads journal collection development, licensing, acquisitions, and collection analysis. He collaborates with a Collection Management Technology (CMT) team on collection analysis. They have reported their leading edge work  in presentations and publications. Learn more information about the CMT team’s work.

Register to attend.

Sponsored by Minnesota Libraries