Training
Excel Basics and Beyond Module 3 – Fall 2026
Build advanced Excel skills to analyze complex data, improve reporting, and make more informed decisions.
Take your Excel skills further with advanced formulas, data analysis tools, and Pivot Tables. This course covers formula auditing, IF and SUMIF functions, INDEX/MATCH, the Analysis ToolPak, and advanced Pivot Table techniques to help you analyze information, troubleshoot errors, and create more useful reports.
What You’ll Learn
- Audit formulas to identify and correct errors
- Use IF and SUMIF functions for advanced calculations
- Apply INDEX/MATCH to find and retrieve data
- Use the Analysis ToolPak to analyze data
- Create and work with advanced Pivot Tables
- Analyze complex data to support reporting and decisions
Performance Improved
- More accurate calculations and analysis
- Faster identification and correction of formula errors
- Less manual work with complex data
- More effective use of Pivot Tables
- Clearer reporting of trends and results
- Better data-driven decisions
Course Details
Course Format
- One 3-hour class
- Advanced-level Excel training
- Maximum class size: 15
Prerequisites
- Good working knowledge of Excel, including formulas, functions, and basic data analysis.
Funding
- WEDnetPA eligible, subject to eligibility and funding