BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//ABC Keystone - ECPv6.17.5.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:ABC Keystone
X-ORIGINAL-URL:https://abckeystone.org
X-WR-CALDESC:Events for ABC Keystone
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20270314T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20271107T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20261008T080000
DTEND;TZID=America/New_York:20261008T110000
DTSTAMP:20260610T193836Z
CREATED:20260610T191928Z
LAST-MODIFIED:20260610T193836Z
UID:10000518-1791446400-1791457200@abckeystone.org
SUMMARY:Excel Intermediate – Module 2
DESCRIPTION:Manheim Office\n135 Shellyland Road\nManheim\, PA 17545 \nDon’t wait to register! Class size is limited to 10 participants to ensure a hands-on learning experience. \n\nExcel Intermediate is a great follow-up to the Excel Basics & Beyond class. This course builds on foundational skills by exploring the design and functionality of well-structured worksheets. Participants will gain a deeper understanding of how worksheet design impacts Excel’s ability to function effectively and efficiently. \nThis class is also an excellent refresher for individuals who have used Excel in the past and want to strengthen their skills before moving on to more advanced functions. Throughout the course\, participants will learn valuable tips and shortcuts to increase efficiency and productivity. \nHighlights of the class include advanced sorting and filtering techniques\, creating formulas to analyze filtered data\, and utilizing new and enhanced features available in Excel 2019 and Microsoft 365. \nTopics to be covered in this course are: \n\nVlookup vs XLookup (formula)\nConcat (formula)\nSubTotals (formula)\nSorting & Filtering Data\nSlicers to filter a list\nCopy and Print Filtered Lists\nSubtotals Reports\nConditional Formatting\nAdvanced Printing (selections\, multiple worksheets\, headers/footers\, page breaks)\n\n\nInstructor: \n \nLiz Hornberger\, President & Founder of PC Focus \nPC Focus began its 35th year\, on January 15\, 2025\, providing training and other services in Central Pennsylvania. Elizabeth Hornberger\, president of PC Focus\, founded the company in January 1990. Liz has been in the computer training and development business for over 35 years. She continues to run PC Focus with the same philosophies that sparked this career many years ago. \nLiz is also a part-time adjunct professor\, teaching Gen ED computer classes at in Lancaster. It is a privilege to teach and to prepare students for “real-life” and how computers will impact them now and in their future endeavors. This semester\, with four classes and nearly 80 students\, I have many opportunities to make a difference. \n\nRegistration Details:\n \nIf you must cancel for any reason\, please get in touch with us immediately. Cancellations received less than seven days after class start cannot be refunded; substitutions are permitted. \nRegistration deadline: Seven days before the session date\n \nABC Members may select the option to be invoiced. Non-members will need to pay at the time of registration either via credit card payment online or by calling the Chapter office: (717) 653-8106. \nEIN: 23-1618254 – Contributions or gifts are not deductible as charitable contributions for federal income tax purposes. However\, members may deduct payments as an ordinary\, necessary business expense. See your accountant for details.
URL:https://abckeystone.org/event/excel-intermediate-module-2-2/
LOCATION:Manheim Office\, 135 Shellyland Road\, Manheim\, PA\, 17545\, United States
CATEGORIES:Career Development,Microsoft
ORGANIZER;CN="Leslie Hodges":MAILTO:leslie@abckeystone.org
GEO:40.1232798|40.1232798;-76.470678|-76.470678
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Manheim Office 135 Shellyland Road Manheim PA 17545 United States;X-APPLE-RADIUS=500;X-TITLE=135 Shellyland Road:geo:-76.470678|-76.470678,40.1232798|40.1232798
END:VEVENT
END:VCALENDAR