Excel Intermediate Training

Program Details

Program Highlights

  • Boost your EXCEL skills with half-day workshops
  • Become more productive and efficient with your spreadsheets
  • Strengthen the visual impact of your numerical data
  • Learn new things about EXCEL that you didn't know were even possible

Who Should Attend

  • Working professionals who want to enhance their performance and productivity with EXCEL

EXCEL 2016: Creating Advanced Formulas & Data Analysis | September 1

In this workshop, you will learn how to use range names in formulas and functions, as well as how to use specialized functions. You will also learn how to analyze data by using text, logical, lookup, date, and financial functions. By learning how to use advanced formulas and functions, Excel will save you time and reduce errors when conducting data analysis.

EXCEL 2016: Organizing Worksheet Data with Tables & Charts | September 8

This workshop will teach you how to create and modify tables, sort and filter data, use subtotal features, and work with database functions. You will learn how to create charts, as well as modify and format existing charts. You will also learn how to create a trendline and create advanced charts.

EXCEL 2016: Using PivotTables, PivotCharts, & Graphics | September 15

This workshop will teach you how to create a PivotTable, filter data using slicers, and analyze data using PivotCharts. During this session, you will also learn how to insert, modify, layer, and group graphical objects. You will also take a look at how to incorporate SmartArt into workbooks.

EXCEL 2016: Using PivotTables, PivotCharts, & Graphics | September 22

In this final session, you will learn how to customize workbooks, manage themes, and create and use templates. Protecting files and preparing a workbook for multiple audiences will also be covered. This session also includes a "Bring It All Together" class project to test all newly acquired skill sets.

Registration

Class Dates & Times

Wednesdays, September 1, 8, 15, & 22, 2021 - 1:00 - 5:00 pm

Class Location

SCCCD Herndon Campus, 390 W Fir Avenue, Building A, Room 106, Clovis, CA 93611

Registration Fee

  • $99 - Per Person, Per Session, Class Materials
  • $320 - Per Person, All 4 Sessions, Class Materials
  • $50 - With ETP for Qualifying Companies
    • Qualifying companies can send employees for a discounted rate of $50 (all 4 sessions) through the Employment Training Program (ETP) funded by the Employment Training Tax. Contact Celia Zamora for additional information.

Space is limited! Online registration in advance is required! Call 559.243.7534 with questions.

Quicklinks
Apply For Admission
Calendar
Campus Map
Class Schedules
Counseling
Faculty/staff Directory
Financial Aid &
Scholarships
Human Resources
Campus
Crime Alerts
Clery Report
District Police
Measure C
Jobs
News
Parking
Other Colleges
Reedley College
Madera Community College at Oakhurst
Fresno City College
Clovis College
State Center Community
College District (SCCCD)
Progress & Performance
Accreditation
Strategic Planning
Accessibility
Associate Degree
For Transfer
Student Success
Scorecard
Gainful Employment
Net Price Calculator