Dates: September 10, 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
Join us for a comprehensive one-day course designed for beginners or self-taught users eager to enhance their Microsoft Excel skills. As the first course in the Excel Application Specialist certification series, Excel Level I will equip you with essential Excel skills and introduce more advanced features to help you work more efficiently and effectively. By the end of the course, participants will have the tools needed to create, manage, and navigate spreadsheets confidently, boosting productivity and ensuring that you make the most out of Excel’s powerful functionalities.
What You’ll Learn:
Getting Started with Excel: Navigation and Selection
Understand the layout of the Excel interface.
Learn to navigate through cells, rows, columns, and worksheets.
Master selection techniques to highlight individual cells, ranges, and entire rows/columns.
Using AutoFill to Save Time
Discover how to quickly extend data patterns like numbers, dates, and simple formulas across rows and columns using Excel’s AutoFill feature, streamlining your workflow.
Printing From Excel
Learn how to set up print areas, adjust page layouts, and preview your spreadsheet to ensure it prints correctly and looks professional.
Intro to Formulas: Proper Formula Layout, Common Formulas, Using AutoFill
Get hands-on experience creating simple formulas and applying basic operations (addition, subtraction, etc.) across multiple cells using AutoFill.
Intro to Functions: SUM, COUNT, AVERAGE, MAX, MIN
Master essential Excel functions including SUM, COUNT, AVERAGE, MAX, and MIN to perform quick calculations and analyze data efficiently.
Formatting Worksheets for Readability
Learn how to format cells, rows, and columns to improve the appearance of your spreadsheets. This includes adjusting text alignment, font styles, number formatting, and adding borders and shading for better presentation.
Managing Large Workbooks: Organizing Worksheets and View Settings
Discover strategies for managing large workbooks by organizing multiple worksheets and using different view options (Page Layout and Normal views). Navigate large datasets with ease.
Customizing Excel Options to Suit Your Needs
Explore how to personalize Excel’s settings, including adjusting the Ribbon, managing default settings for formulas, and customizing data entry and calculation preferences.
Why Attend:
Gain foundational skills that will make you more efficient in handling spreadsheets and performing essential Excel tasks.
Learn time-saving techniques, such as AutoFill and using formulas/functions, to boost productivity.
Enhance your ability to manage large datasets and present data professionally.
By the End of This Course: You will have a solid understanding of Excel’s core features and be able to navigate, format, and manage data confidently, setting you up for success in the next stages of the Excel certification series.
Register now and take the first step towards mastering Microsoft Excel!
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