Learning Outcomes

• By the end of the session, participants will be able to conduct an e-resource value analysis using Excel, COUNTER 5 reports, and a list of annual costs.
• Participants will be able to use Excel PowerQuery to pull in data from other Excel files or a variety of sources like databases, Power BI datasets, or SharePoint.
• Participants will be able to use Excel PowerQuery to compile multiple Excel files into a single table.
• Participants will be able to create pivot tables and choose different ways to compile data like sum, count, average, or percent of total.
• Participants will be able to unpivot data tables and identify when unpivoting data is appropriate.
• Participants will be able to use SUMIFS to use multiple conditions when finding the sum of a column of data.
• Participants will be able to use Excel’s AND and OR functions to create complex SUMIFS statements.
• Participants will be able to use Excel’s IFERROR function to handle data problems such as dividing by zero.
• Participants will be able to use Excel’s Percent Rank function to rank the value of e-resources based on inflation, usage, and cost-per-use.
• Participants will be able to use Conditional formatting to highlight high, low, or invalid values.

Please download these files onto your local machine: https://bit.ly/lac-2024-excel

View Slides (PDF)