February 27 2020 - 14:00
About the Event
Many librarians use Microsoft Excel to analyse usage. The new COUNTER 5 report formats can present some initial hurdles. This webinar focusses on the most frequently asked questions sent to COUNTER since the launch of Release 5:
- How do I import tsv reports?
- How do I add totals to a report?
- How do I compare 2019 data to 2018?
- How can I ingest SUSHI-harvested data into Excel?
Register for this recording
You may still register for the recording of the webinar by visiting the GoToWebinar site.
Material recommended by Kornelia Junge during the session:
- COUNTER Foundation Class 10: Working with COUNTER 5 reports in Microsoft Excel - This video is part of a series of COUNTER foundation classes.
Please, find here the Q&A document that our speaker has kindly put together.
Senior Research Manager at Wiley, Member of the COUNTER Executive Committee and COUNTER Technical Advisory Group.
As Senior Research Manager at Wiley, Kornelia is responsible for the customer-facing and internal usage reporting of the Wiley Online Library. She is a member of the COUNTER executive committee and the COUNTER Technical Advisory Group and has been part of the working group that developed COUNTER 5.
She joined the publishing industry in 1990 and has held various positions in marketing and market research at Wiley and Springer. She has been involved with usage statistics since 2001. With a background in psychology and social sciences, focusing on statistics and methodology, her main interest is on developing meaningful metrics and ensuring data quality in the measurement of online behaviour.
After this webinar attendees will be able to:
- Import reports in tsv and json format
- Add totals to reports
- Compare data from two reports
- Create Pivot tables
Subject level and previous knowledge required
Basic knowledge of Excel
This is a free webinar and is open to members and non-members of UKSG alike.
To register, please visit the Citrix/GoToWebinar site. (Citrix is our webinar service provider.)
Unable to attend? Register anyway and we will send you a link to a recording of the webinar after the event. If you have already registered and are subsequently unable to attend, please do not cancel your registration - only active registrations will receive the recording in a follow-up e-mail.
To help you prepare for UKSG webinars, you may like to read the Notes for Participants:
Follow the webinar on Twitter: #UKSGwebinar
If you have particular accessibility needs, please feel free to contact Samira Koelle.
UKSG webinars are for educational and information purposes only. The views and opinions expressed in UKSG webinars are the personal views and opinions of the speaker(s) and do not necessarily represent or reflect the views or opinions of UKSG, its employees or agents.
Content, information or links are provided for information purposes only and do not constitute or imply an endorsement, sponsorship, authorisation, affiliation or recommendation by UKSG or any other party. Any reliance on the webinars or any content, information or links is therefore at your own risk.
Feedback from previous webinars.
Inspiring and confidence-building - you'll find yourself looking for ways to use what you've learned the moment you leave the webinar!
A useful programme of relevant webinars.
Highly recommended and always informative!
If you have already registered and are subsequently unable to attend, please do not cancel your registration - only active registrations will receive the recording in a follow-up e-mail.
NB: UKSG reserves the right to alter or vary the programme due to events or circumstances beyond its reasonable control without being obliged to refund monies.