PennTRAIN: Microsoft Excel for Transit Professionals

  • 08/12/2019
  • 08/13/2019
  • Lebanon Transit in Lebanon, PA


Registration is closed

Monday, August 12, 2019 – 10 AM to 5 PM
Tuesday, August 13, 2019 – 8 AM to 3 PM

This two-day course will discuss how Microsoft Excel is used to manage, analyze and present data.  The main topics of the course are listed below:

  • Working with Data Sets
  • Sorting and Filtering
  • Tables
  • Conditional Formatting
  • Formulas and Functions
  • Charting
  • Pivot Tables
  • Automation (Macros and VBA)

The course has been structured to give the students plenty of hands-on activities to help solidify their practical understanding of the material covered.  In addition, transit related datasets and examples will be used to ensure the course is aligned with the student’s needs.

Attendees are encouraged to outline any specific needs on their registration form, so that these can be incorporated into the curriculum. A follow-up webinar will be offered several weeks later to address any questions that may arise in the course of applying these skills in a live environment.

Presenters: JD Kronicz and Rich Williams, Data Centric Services

Cost: $49 per person (PPTA's cancellation policy applies)

Equipment: Attendees will need a laptop with Excel 2010 or newer to participate in this course. PennTRAIN has a limited number of laptops that can be loaned to attendees, though we ask that you provide your own if possible. Loaner laptops will be allocated upon registration on a first-come, first-served basis.

Parking: Free parking is available in Lebanon Transit's parking lot.

Lodging: PennTRAIN has secured a block of rooms at the Hampton Inn Lebanon, located at 1601 E Cumberland St, Lebanon, PA 17042. The room block is available for the nights of August 11 & 12 at the government rate of $94/night plus taxes. Guests will receive a complimentary hot breakfast at the hotel. Click here to book online, or call (717) 277-7221 and ask for the PA Public Transit rate. The block will be released on July 29, 2019 or when sold out. 

Meals: A light breakfast, lunch, and breaks will be provided. Please inform Sara Bowden at of any dietary restrictions at least one week in advance.

Attire: Casual. Because it can be a challenge to keep the meeting room at a temperature that accommodates everyone, we recommend bringing a sweater or jacket to stay comfortable.

Lebanon Transit is located at:
200 Willow Street, Lebanon, PA 17046

Pennsylvania Public Transportation Association is a 501(c)6 non-profit organization. 115 Pine Street, Harrisburg, PA 17101

Powered by Wild Apricot Membership Software