New Kensington campus offers noncredit computer software courses during summer

Training in OSHA, Excel, VBA

NEW KENSINGTON, Pa. — Noncredit courses offered through the Office of Continuing Education at Penn State New Kensington include training for OSHA standards, working with the computer software program Excel, and programming with Visual Basic for Applications (VBA). Geared to adult learners, the courses do not carry college credit and are designed to meet specific skill developments.

The OSHA (Occupational Safety and Health Act) 10-Hour General Industry training course runs from 8 a.m. to 1 p.m. Wednesday and Thursday, May 31 and June 1, in the campus Conference Center. The 14 topics feature walking and working surfaces, hazard communication, material handling, machine guarding, blood borne pathogens and ergonomics. Participants completing the course receive an official DOL/OSHA card. The cost is $250 and includes materials, breakfast and lunch.

Excel is an electronic spreadsheet application that organizes data into rows and columns, and performs mathematical calculations. The three levels — basic, intermediate and advanced — are set from 1:30 to 5 p.m. on Tuesday and Thursday for three consecutive weeks in the campus’ Information Technology Center. The cost is $140 for each course. The courses will be taught by Skip Laratonda, adjunct instructor in engineering and the 2016 recipient of the campus’ Excellence in Teaching award

Basic Excel is scheduled for June 6 and 8. Students can learn formatting, using functions, sorting and entering data, and using multiple files and workbooks.

Intermediate Excel follows on June 13 and 15, and builds on the concepts of the basic course. Learners can acquire the skills to protect data, name cells and ranges, use filtering techniques, If Statements, conditional formatting, templates, and the macro recorder, track changes and work with multisheet workbooks.

Advanced Excel concludes the series on June 20 and 22. Students can acquire the skills to work with advanced filters, data and statistical analysis functions, Toolpak and dialog box controls.

The dates for the VBA are in the process of being scheduled. The course will introduce macro programming using VBA to automate and customize operations in Word, Excel, and Access. Using the Visual Basic editor, participants can create user interfaces, write VBA code, execute and debug programs.

For more information or to register for courses, call 724-334-6011 or email Beth Nury.

Contacts: 

Bill Woodard

Alumni and Public Relations Specialist

Work Phone: 
724-334-6049
Home Phone: 
724-335-0473
Cell Phone: 
724-594-8421