PennTRAIN: Microsoft Excel for Transit Professionals

  • 06/05/2019
  • 06/06/2019
  • Centre Area Transportation Authority (CATA) Administrative Office


Registration is closed

Wednesday, June 5, 2019 – 10 AM to 5 PM
Thursday, June 6, 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: No charge

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.

Shuttle Transport: CATA has very limited parking options at this time. To best accommodate you, CATA is providing a shuttle, which will depart from the front of the Courtyard by Marriott at 9:40 AM on Wednesday, and 7:40 AM on Thursday. The Courtyard is located at 1730 University Drive, State College, PA 16801, and parking there is free and plentiful. The shuttle will return to the Courtyard at the conclusion of each day’s training. Please utilize this shuttle to avoid parking at CATA and potentially impacting their operations.

Lodging: Courtyard by Marriott (1730 University Drive, State College, PA 16801) Room block is available for the nights of June 4 & 5 at the government rate of $101/night plus taxes. Click here to book online or call 814-238-1881 (ask for PennTRAIN block). Rooms will be released on May 3 (or when sold out).

Meals: 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.

Centre Area Transportation Authority (CATA) Administrative Office is located at:
2081 W Whitehall Road, State College, PA 16801

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

Powered by Wild Apricot Membership Software