(559) 243-7530
COMPUTER APPLICATIONS
Microsoft Excel 365 - 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
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
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