Skip to main content

Project 2: The Weeding Report

Let’s prepare a weeding report from sample physical collections data. For this project, we’ll continue learning how to use functions effectively. We’ll calculate how many years ago an item was acquired or circulated. We’ll look at a simple method to combine these calculations as a single variable we can use efficiently to identify candidates for weeding. We’ll use conditional formatting and other techniques to improve the legibility of our report.

Image
excel series
Staff contact
Ann Kaste

Outreach & Instruction Librarian, K-12 Outreach Coordinator