ER&L Preliminary Program Search Tool
March 3–6, 2024
Austin, Texas + Online
We are pleased to share the 19th program of the Electronic Resources and Libraries Conference reflecting our work to support the way we collect, manage, maintain, and make accessible electronic resources.
- View the Program in a Day by Day View
- Register to Attend ER&L (In-person or Online)
No-code methods for automating regular reporting in Excel
Online Conference Platform
Conference Track
2. Collection Development & Assessment
Audience Level
Foundation
Keywords
report automation
Abstract
Providing library personnel with regular reports on acquisitions and resource usage supports day-to-day decision-making and collaboration among departments. This presentation demonstrates how a medium-sized library increased their capacity for regular reporting by using Excel’s Power Query to automate data extraction from multiple sources, data cleansing, and report generation.
Presenters
Sidonie Devarenne, Western Washington University
Loading…