Calendar

Manheim Office
135 Shellyland Road
Manheim, PA 17545

Description:

The Excel – Intermediate Part II course expands on Excel’s advanced capabilities, focusing on file management, formatting, data protection, and automation. Students will learn to open multiple files, apply password protection, display formulas, and protect or unprotect worksheets. The course covers working with range names, customizing page setup and print settings, and using features like Fill Series, manual recalculation, and AutoRecover.

Participants will explore advanced formatting techniques—such as applying colors, borders, and shading—along with tools like Format Painter, text wrapping, and inserting graphics and text boxes. Additional topics include splitting windows, linking data, inserting comments, and using Find and Replace. The course also introduces basic macros, including recording and running them, giving users more control and efficiency in managing their spreadsheets.

Course Prerequisite:

Must have Excel – Intermediate Part I or equivalent experience

Microsoft Excel Series

The Microsoft Excel Series is a comprehensive training program designed to guide learners from basic to advanced Excel skills. Each course builds on the previous one, offering practical, hands-on learning that helps users become more confident and efficient in analyzing, organizing, and presenting data in Excel.

4 Session Series * Classes cycle continuously, join any time at series rate.

Microsoft Excel: Basics | October 28, 2025

Microsoft Excel: Intermediate Part I | November 5, 2025

Microsoft Excel: Intermediate Part II | November 11, 2025

Microsoft Excel: Advanced | November 18, 2025

Instructor:

Edie Margolis, PC Easy

Founder and President of PC Easy, Edie has been teaching computer classes since 1985. Edie is able to teach all of the classes shown in the Course Outlines. She also writes all of our manuals and does consulting for many area businesses.

Edie has an associate’s degree from F&M and an applications software background as a user from working for several of Lancaster’s major employers. She was always the “go to” person for answers to computer or software related questions. She knows firsthand what Managers and CEOs are looking for in Documents, Data Analysis, Charts, and Presentations.

Edie takes great pride in her training and provides superior quality and consistent presentation for each class taught.

Registration date: Seven days prior to session date.

Price includes: Instruction and Interactive Role-Play Activities

If you must cancel for any reason, please contact us immediately.
Cancellations received less than 7 days of the start of class cannot be refunded; substitutions are permitted.

ABC Members may select the option to be invoiced.
Non-members will need to please pay at 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, payments may be deductible by members as an ordinary, necessary business expense. See your accountant for details.

Not a Member? Contact Mike Bachman at mike@abckeystone.org.