Regular tracking of metrics like submissions, acceptances, and turnaround time is key to assessing a journal’s performance. Manually adding new data to a tracking document can take hours, and copying and pasting across various tabs and files is likely to introduce errors. Wouldn’t it be easier if Excel would ingest the raw data from your submission system report and update your document automatically? Great news, with just a little bit of setup, it can!

Join Kevin Jewett, Program Coordinator for Publications Statistics at the American Geophysical Union, as he shows you how to go from raw report data to interactive charts and tables in minutes, and then, how to add new data to your document in just a single click.

This live demo will cover:

• Importing and loading data from files and folders using Power Query
• Basic Power Query data transformations
• Basic data modeling and lookup tables
• PowerPivot charts and tables
• Refreshing queries and PowerPivot charts and tables
• The XLOOKUP function

This Office Hours event is part of the Early Career Committee’s 101 Series, where we cover the skills and knowledge needed for the day-to-day work of scholarly publishing professionals.

Hosted by:
Kevin Jewett, Program Coordinator for Publications Statistics, American Geophysical Union

About Office Hours with ISMTE
Office Hours are virtual, One-hour informal events where a single topic is discussed by the participants. ISMTE Office Hours are facilitated by an ISMTE member who has an interest in the topic at hand.
These sessions are free and open to all editorial professionals regardless of member status.