Dates: October 22, 2026
Time: 9:00 am – 4:00 pm
Cost: $230 members, $325 non-members
Location: Community Education Center (CEC)
4 Erie Avenue, St Marys, PA 15857
Event Overview
Take your Excel skills to the next level with Excel Level II, the second course in the Excel Application Specialist certification series. This one-day, advanced course is designed for users who are already familiar with Excel and want to deepen their proficiency. Participants will dive into more complex features, including creating and formatting charts, working with PivotTables, applying advanced formulas, and automating tasks. By the end of the day, you’ll be able to handle sophisticated tasks with ease, boost your data analysis capabilities, and increase your productivity.
What You’ll Learn:
Reviewing Cell Names & Applying Range Names
Learn how to assign and use named ranges, making formulas simpler and improving worksheet navigation for easier data management.
Using Specialized Functions: SUMIF, COUNTIF, AVERAGEIF, and PMT
Master specialized functions to perform conditional calculations and financial analysis based on specific criteria or parameters. Perfect for analyzing data efficiently.
Text Functions: LEFT, RIGHT, MID, TEXTJOIN, TRIM, UPPER, LOWER, and PROPER
Discover how to manipulate and clean data with essential text functions, including extracting substrings, combining text, and adjusting text case for consistent data presentation.
Logical Functions: AND, IF, OR
Learn to apply logical functions such as AND, IF, and OR to create powerful conditional statements that return specific results based on given criteria.
Excel Charts
Gain the skills to create various chart types (bar, line, pie, etc.) and use them to visually represent your data, turning numbers into insights for more compelling reports.
Lookup Functions: LOOKUP, VLOOKUP, and INDEX & MATCH
Master advanced lookup functions, including VLOOKUP and the combination of INDEX & MATCH, to retrieve data from large datasets based on specific search conditions.
Excel Tables
Learn how to convert data into Excel Tables for automatic expansion, easier sorting and filtering, and structured references in formulas for more dynamic data management.
PivotTables, Slicers, and Pivot Charts
Dive into PivotTables to summarize and analyze large datasets, enhance reports with interactive Slicers, and create dynamic Pivot Charts for compelling visualizations.
Themes and File Protection
Understand how to apply and customize Excel Themes for consistent formatting and explore techniques for protecting workbooks and worksheets to control access and prevent unauthorized changes.
Why Attend:
Expand your Excel expertise by mastering more advanced tools for data analysis and presentation.
Learn to automate tasks and streamline workflows with powerful functions and features.
Improve the quality of your reports and analysis using PivotTables, charts, and lookup functions.
By the End of This Course: You’ll be well-equipped to handle advanced Excel tasks, from creating dynamic reports to efficiently managing and analyzing large datasets, all while increasing your productivity.
Register now to take the next step in becoming an Excel expert!
All courses are conducted by a Microsoft Certified Excel Expert. Course hours are from 9:00 AM to 4:00 PM, with a one-hour lunch break provided for personal time.
Casey Naylon
Manufacturer & Business Association|Computer Trainer and Database Administrator