COMPUTER APPLICATIONS

Microsoft Excel - Intermediate Skills

Microsoft Office - Intermediate

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.

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

Sep 9, 2025
Sep 16, 2025
Sep 23, 2025
Sep 30, 2025

In-Person Class
Space is Limited
Registration Closes:
Sep 9, 2025 or When Class is Full
Check-In: 12:30 PM - 1:00 PM
Class: 1:00 PM - 4:00 PM
Promo Code: XCELSEP25
Save 10% Off - Expires Aug 12, 2025

Nov 21, 2025
Nov 24, 2025
Nov 26, 2025
Dec 1, 2025

In-Person Class
Space is Limited
Registration Closes:
Nov 20, 2025 or When Class is Full
Check-In: 5:30 PM - 6:00 PM
Class: 6:00 PM - 9:00 PM
Promo Code: XCELINTNOV25
Save 10% Off - Expires Oct 21, 2025

Microsoft Office
Professional Skills
Bundle

20% off the retail price

Includeds:
Microsoft Word - Foundation
Microsoft Word - Intermediate
Microsoft Excel - Essentials
Microsoft Excel - Intermediate
Microsoft PowerPoint
Microsoft Outlook

Training Location

Herndon Campus, 390 W. Fir Ave., Bldg. A, Rm. 214, Clovis, CA 93611

We Are Hiring

SEARCH

Can't Find What You're Looking For?