Excel Intermediate Training
Program Details
Program Highlights
Go Beyond the Basics - Analyze, Visualize, and Excel
Take your Excel expertise to the next level with this interactive, hands-on workshop series designed for professionals ready to move beyond foundational skills. Whether you’re managing large datasets, creating insightful reports, or building visual dashboards, this course will help you utilize Excel’s powerful tools to work faster and smarter.
Program Highlights:
- Half-day sessions designed for busy professionals
- Hands-on practice with activities and scenarios
- Increase your productivity and reduce errors
- Learn advanced formulas, PivotTables, and dynamic charts
- Earn a certificate of completion and validate your skills with OPAC testing
Who Should Attend?
This program is ideal for office professionals, analysts, managers, and Excel users who want to boost productivity with advanced Excel tools, analyze and visualize data more effectively, and streamline workflow and reporting processes.What You Will Learn
Session 1: Creating Advanced Formulas & Data Analysis
- Use range names in formulas
- Apply logical, lookup, text, date, and financial functions
- Build smarter spreadsheets that work for you
Session 2: Organizing Data with Tables & Charts
- Create and format tables
- Sort, filter, and summarize data
- Design impactful charts and add trendlines
- Build advanced chart types for deeper insights
Session 3: PivotTables, PivotCharts, & Graphics
- Build dynamic PivotTables and filter data with slicers
- Create and customize PivotCharts
- Incorporate SmartArt and graphical objects into reports
Session 4: Enhancing Workbooks + Final Project & OPAC Testing
- Customize themes and templates
- Protect workbooks and prepare for distribution
- Apply all your skills in a capstone project
- Validate your knowledge with OPAC testing and receive a certificate
In-Person Class Dates & Times
- Friday, March 6, 13, 20, & 27, 2026 | 1:00 pm - 4:00pm
- Check-in: 12:30 pm - 1:00 pm
- Registration closes March 5, 2026, or when class is full.
- March 2026 Excel Intermediate Skills Registration (click here)
Class Location
Registration Fees
Public Offering:
- $399 - Registration fee per person
- Includes all training materials and OPAC certification exam.
Policies & Questions
Cancellation Policy:
Cancellations received up to five (5) working days before the course start date are refundable, minus a $25 processing fee. After that, cancellations are subject to the entire course fee. Please note that if you don't cancel and don't attend, you are responsible for payment.
Questions or Concerns:
Contact Program Lead, Andrea Torrez for additional information, or call 559-243-7538
