COMPUTER APPLICATIONS

Microsoft Excel 365 - Intermediate Skills

Excel Intermediate Page Picture

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

General Public

  • $355 – Regular Registration
  • Includes All Training Materials

*ETP Employer Sponsored

  • $149 – ETP Eligible Employer Rate Per Person
  • Includes All Training Materials

*Qualifying companies can send employees for a discounted rate of $149 for 4 days of training through the Employment Training Program (ETP) funded by the Employment Training Tax.

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: Celia Zamora
Telephone: (559) 243-7534

March 11, 2025
March 18, 2025
March 25, 2025
April 1, 2025

In-Person Class
Space is Limited
Registration Closes:
Mar 10, 2025 or When Class is Full
Check-In: 12:30 PM - 1:00 PM
Class: 1:00 PM - 5:00 PM

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?