Calendar

Manheim Office
135 Shellyland Road
Manheim, PA 17545

Description:

The Excel Advanced course is designed for experienced users who want to master powerful data analysis and automation tools in Excel. The course covers advanced features such as data consolidation (with and without links), linking files, and using functions like COUNTIF, SUMIF, and nested IF statements. Participants will learn how to use lookup tables, data validation, subtotals, outlining, and additional database functions for efficient data management.

Advanced macro techniques are introduced, including recording, modifying code, assigning macros to buttons, and using auto-execute features. The course also explores PivotTables, text manipulation tools like Text to Columns and concatenation, and creating custom toolbars. A strong emphasis is placed on advanced charting techniques, including combination charts, trendlines, Pareto charts, and histograms. By the end, users will be equipped to handle complex data tasks and create dynamic, visually impactful reports.

Course Prerequisite:

Must have Excel – Intermediate Part II 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.