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.
What we'll learn or review: additional formatting; convert numbers stored as text to numbers; functions: Len(), CountIf(), CountIfs(), Year(), If(), And(), IsError(), IsNumber(), Index(Match); basic pivot charts; basic conditional formatting.
