The presentation slides, blank and completed example files and a space for online discussion are all available on the P2P KSN website, here:
http://blogs.cam.abtassoc.com/MethodsCenters/?page_id=3266
The Peer2Peer Knowledge Sharing Network
presents:
Excel Essentials for Project Application
Introduction to Excel Database Development Formulas: Focus on Lookups
Annelise Mesler, Presenter
The Peer2Peer Knowledge Sharing Network presents its second Learn Session in a three-part series on Excel Essentials. This session is an introduction to more complex database development formulas, focused on lookups and reference formulas. It also includes tips for creating clear, reproducible Excel analyses. The session is intended to demonstrate and start a discussion of Excel best-practices and tips that will be useful for all staff who use Excel to manage and analyze data.
The presentation will walk through a live example using data from an ERD project linking Toxics Release Inventory (TRI) data to electric utility fuel consumption. Participants are encouraged to work along on their computers during the session and complete the example in real time (bring your computer if you are attending in the conference room). Files will be available for download prior to the session.
Annelise is an Associate Analyst in the Environment and Resources Division. She uses Excel in a variety of projects, including for policy and data analysis using data from EPA’s publically available Toxics Release Inventory (TRI) database. Annelise uses VLOOKUP frequently for her projects and has more recently learned the power of MATCH and INDEX-MATCH formulas for project work application.
The presentation slides, blank and completed example files and a space for online discussion are all available on the P2P KSN website, here:
http://blogs.cam.abtassoc.com/MethodsCenters/?page_id=3266
Tuesday August 12, 2014 12:00 – 1:00 PM
Locations
Capitol Room, Bethesda; Ramp Room 3, Cambridge; and Hatteras Room, Durham
Telecommuters, please call in:
Domestic telecommuters: 1-888-446-7584
International telecommuters: 1-212-372-3742
Participant code: 8350358
(Reminder: all callers will be muted. Please type any questions in the GoToMeeting chat box)
To view the slides:
https://www1.gotomeeting.com/join/732798833
Meeting ID: 732-798-833