Subject: Tomorrow at noon: Excel: Lookups - presentation and examples now available
From: Rep Cap <[email-masked]>
Date: Mon, 11 Aug 2014 20:44:24 +0000

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