In complex worksheets, where the value in one cell impacts several other
cells and formulas, it’s helpful to understand the relationship between
those cells—especially if it’s a spreadsheet you didn’t personally
create. This tip will help you troubleshoot and understand what’s going on.
Select a cell in your worksheet and then press Ctrl-Shift-] (that’s
Control-Shift-Right Bracket) and all of the cells that are dependent on the
selected cell will be highlighted.
Please join us in welcoming the following new hires:
Full-time:
Amanda Peters – Coal and Coke Heritage Center Archivist, Penn State Fayette
Wishing the following employees well as they leave us:
Wilson Hutton – Public Relations and Marketing
Eloise Ingram – Education and Behavioral Sciences Library
Deb Shelow – Acquisitions Services
Beth Matocha – Penn State New Kensington
Summer 2016
Tuesday, June 7–Friday, July 29: “Central Pennsylvania Festival of the Arts at 50: Making Lasting Memories” exhibit, Special Collections Library, open 9 a.m.- 5 p.m. Monday-Friday (summer hours).
Monday, June 27: finals day, first six weeks summer session, University Park.
Monday, June 27: Job enrichment informational session, hosted by Carman Gass, User Services Training coordinator, 11 a.m.-noon, Mann Assembly Room, University Park.
Tuesday, June 28: Bibliography publishing in the Libraries, Join Publishing & Curation Services and Sandy Stelts for a presentation on publishing bibliographies online, with speaker Lyman Tower Sargent, author of Utopian Literature in English: An Annotated Bibliography From 1516 to the Present, 3-4 p.m., Mann Assembly Room.
Wednesday, June 29: first day, second six weeks summer session, University Park.
Wednesday, June 29: Gallery Talk by Rick Bryant, Central Pennsylvania Festival of the Arts executive director, in conjunction with the University Archives exhibit “Central Pennsylvania Festival of the Arts at 50: Making Lasting Memories,” noon-1 p.m., Foster Auditorium, Paterno Library, University Park.
Monday, July 4: Independence Day, no classes. All library locations closed.
Tuesday July 12, Working with International Patrons, training session by Carmen Gass, User Services training coordinator, 1:30-3:30 p.m., Foster Auditorium and online via MediaSite Live, University Park.
Wednesday-Sunday, July 13-17, Central Pennsylvania Festival of the Arts 50th anniversary, Children’s Day July 13, BookFest July 16, State College and University Park campus.
Tuesday, July 19: Coffee with Carmen, the Libraries’ User Services Training Coordinator, 9-10 a.m., Engineering Library.
Wednesday, July 20: Self Defense, training session by Carmen Gass, the Libraries’ User Services Training Coordinator, 10 a.m.-noon, TBD.
Wednesday, July 20: Integrating Sustainability into Your You@PSU Goals, training session by Carmen Gass, the Libraries’ User Services Training Coordinator, 2-3 p.m., Foster Auditorium, Paterno Library and online via MediaSite Live, University Park.
Thursday, July 21, 8 a.m.-4 p.m.: PA Forward Information Literacy Summit, Foster Auditorium, Paterno Library.
Thursday, July 21: PA Forward Information Literacy Summit, Mann Assembly Room, Foster Auditorium and classrooms, Pattee/Paterno libraries, University Park.
Wednesday, July 27: Discovery Day Webinar Series: Breaking News! Worldwide Exclusive! Lionsearch News Tricks Exposed!, presented by Eric Novotny, Jackie Dillon-Fast, Sandy Morgart and Ashoo Kuma of the News & Microforms Library, 1:30-2:30 p.m., TBD.
Monday, August 3–Friday, December 16: “The Expanding World: Penn Staters in the Olympics” exhibit, Special Collections Library.
Tuesday, August 9: 10:30 a.m.-2:30 p.m.: Libraries Clean Up Day, University Park.
Wednesday, August 10: last day of summer classes, University Park.
August 10, 10:30-11:30 a.m.: Tech Update, by Libraries I-Tech staff, Foster Auditorium, 102 Paterno Library, and MediaSite Live.
Friday, August 12: finals day, second six weeks summer session, University Park.
Saturday, August 13: Summer commencement, University Park.
Fall 2016
August 17, 10:30-11:30 a.m.: Tech Update, by Libraries I-Tech staff, Foster Auditorium, 102 Paterno Library.
Friday-Sunday, August 19-21: Arrival days.
Monday, August 22: First day of classes.
Tuesday, August 30: Coffee with Carmen, the Libraries’ User Services Training Coordinator, noon-1 p.m., Mann Assembly Room.
Monday, September 5: Labor Day, no classes.
September 7-8: Open House, 10 a.m.5 p.m., University Park library locations.
Please submit event information to Public Relations and Marketing via the Library News submission form.