[Eril-l] ALCTS webinar: Excel for Technical Services: Intermediate

[ALCTS-CE Announce]

*Cross posted to multiple lists*

ALCTS webinar: Excel for Technical Services: Intermediate

Date: Wednesday, May 20, 2020

All webinars are one hour in length and begin at 11 am Pacific, noon
Mountain, 1 pm Central, and 2 pm Eastern time.



This is part two of a two-part series. Excel for Technical Services:
Introductory <http://www.ala.org/alcts/confevents/upcoming/webinar/042220>
is the companion to this webinar.

This is the second session in a two-part series on features of Excel that
can make data easier to both read and analyze. The presenter will walk
through each step using a report generated from the ILS. The second,
intermediate to advanced, session will show ways to transform data for
analysis, including: importing fields from one spreadsheet into another,
finding duplicates, splitting columns that have multiple values, and using
conditional formatting to help visualize data.

Learning outcomes:

At the end of this webinar, attendees will be able to:

   -

   Use formulas to do basic arithmetic in Excel
   -

   Import data from one spreadsheet into another
   -

   Use conditional formatting to find duplicates or outlier values, and to
   create simple data visualizations
   -

   Split cells that contain multiple values, e.g., multiple ISBNs

Who should attend?

People in the library who use Excel for analysis.

Presenter:

Karen Kohn is Collections Analysis Librarian at Temple University in
Philadelphia, PA and the author of Collection Evaluation in Academic
Libraries: A Practical Guide for Librarians (Rowman & Littlefield, 2015).
She has published articles in College & Research Libraries, Journal of
Academic Librarianship, Journal of Documentation, and Collection Management
and presented at the Charleston Library Conference and the Acquisitions
Institute at Timberline Lodge. In January 2020 she will be teaching the
online course Introduction to Collection Analysis through Library Juice
Academy. She has an MLS from the University of Illinois at Urbana-Champaign
and an MA in Sociology from Temple University.

*****************

Registration fees for one webinar:  ALCTS Member $43; Non-member $59; Group
rate $129

Registration fees for both webinars:  ALCTS Member $69; Non-member $95;
Group rate $206

For additional information and access to registration links, please go to
the following website:

http://www.ala.org/alcts/confevents/upcoming/webinar/052020

ALCTS webinars are recorded and registrants receive a link to the recording
shortly following the live event.

For questions about registration, contact ALA Registration by calling
1-800-545-2433 and press 5 or email registration at ala.org

For all other questions or comments related to the webinars, please contact
alctsce at ala.org

Posted on behalf of the ALCTS Continuing Education Committee.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20200429/0aafd261/attachment.html>