(559) 243-7530
Microsoft Excel – Intermediate Skills
November 21 @ 6:00 PM - December 1 @ 9:00 PM
MICROSOFT EXCEL – INTERMEDIATE SKILLS
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
REGISTRATION FEES
Public Offering:
- $399 – Registration
- Includes all training materials and OPAC certification exam.
- Class Dates: Nov 21, 24, 26 & Dec 1, 2025
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 still responsible for payment.
Questions or Concerns:
Program Lead: Frank M. Nuñez
Telephone: (559) 243-7281
Telephone: (559) 243-7281