Training
Excel Training Series
Build stronger Excel skills to organize, analyze, and use manufacturing data more effectively.
This three-module series gives participants a practical progression from basic worksheet skills through more advanced formulas, Pivot Tables, analysis tools, and automation.
What You’ll Learn
- Module 1 Basics & Beyond Worksheet setup, formatting, basic formulas, multiple sheets, printing
- Module 2 Intermediate Sorting/filtering, XLOOKUP/VLOOKUP, subtotals, conditional formatting, slicers, Pivot Tables
- Module 3 Advanced Auditing, IF/SUMIF, INDEX/MATCH, Analysis ToolPak, advanced Pivot Tables, macros, consolidation
Performance Improved
- Cleaner and more consistent worksheets
- Faster work in Excel
- Fewer errors
- Better reporting
- Stronger data analysis
- More useful information for daily decisions
Course Details
Course Format
- Three separate modules , three hours each
- Module 1: Introductory; no prerequisites
- Module 2: Intermediate; some Excel knowledge helpful
- Module 3: Intermediate–Advanced; good working knowledge required
- Maximum class size: 15
Prerequisites
- None
Funding
- WEDnetPA eligible, subject to eligibility and funding