Calendar

Manheim Office
135 Shellyland Road
Manheim, PA 17545

Don’t wait to register! Class size is limited to 10 participants to ensure a hands-on learning experience.

Excel 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.

This 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.

Highlights 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.

Topics to be covered in this course are:

• Vlookup vs XLookup (formula)
• Concat (formula)
• SubTotals (formula)
• Sorting & Filtering Data
• Slicers to filter a list
• Copy and Print Filtered Lists
• Subtotals Reports
• Conditional Formatting
• Advanced Printing (selections, multiple worksheets, headers/footers, page breaks)

Instructor:

Liz Hornberger, President & Founder of PC Focus

PC 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.

Liz 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.

Registration Details:

If 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.

Registration deadline: Seven days before the session date

ABC 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.

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