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
mardi 5 mars 2024 à 09:45–11:15 CST add to calendar
Online Conference Platform
Tags:
Watch On-Demand/ Online Q&A March 5 @ 9:45-11:15 AM CST/ Short Talk
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.