Training
Excel Basics and Beyond Module 2 – Fall 2026
Work more efficiently with Excel tools that simplify data management, analysis, and reporting.
Build on your foundational Excel skills with practical tools for organizing, analyzing, and managing data. This intermediate course covers sorting, filtering, lookup functions, subtotals, and conditional formatting to help you work more efficiently and make better use of information.
What You’ll Learn
- Sort and filter data to find information quickly
- Use XLOOKUP and VLOOKUP to retrieve information across worksheets
- Organize and summarize data using subtotals
- Apply conditional formatting to highlight trends and exceptions
- Work more efficiently with larger, more complex spreadsheets
Performance Improved
- Faster sorting, filtering, and analysis of data
- Less time spent searching for information
- Fewer errors when working across worksheets
- Clearer identification of trends and exceptions
- More organized and useful reports
- Greater confidence working with complex spreadsheets
Course Details
Course Format
- One 3-hour class
- Intermediate-level Excel training
- Maximum class size: 15
Prerequisites
- Basic working knowledge of Excel, including worksheet navigation, formatting, and simple formulas.
Funding
- WEDnetPA eligible, subject to eligibility and funding