IN PERSON TRAINING - EXCEL INTERMEDIATE

Who Should Attend

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

Please Note:
Proof of Vaccination OR negative test (within 72 hours) will be required for all in person classes. Mask's may be worn on a voluntary basis but are not required.
Policy is subject to change and all changes will be communicated prior to class dates.

REGISTRATION CLOSES TUESDAY, SEPTEMBER 13TH AT NOON!

 

Dates & Times

Wednesdays

September 14, 21, 28 & October 5

1:00 p.m. - 5:00 p.m.

Instructor

Brandon Moody

Where

Clovis Community College Herndon Campus 
390 W. Fir Bldg A Room 104
Clovis, CA 93611
 

 
Driving Directions 

Registration Fee

$320 - Includes all 4 sessions

Class material included in pricing!

*$80 w/ ETP for qualifying companies

Contact

Celia Zamora 
SCCCD Training Institute 
559-243-7534 
celia.zamora@scccd.edu 

  • Boost your EXCEL skills with a half-day workshop
  • 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
EXCEL: CREATING ADVANCED FORMULAS & DATA ANALYSIS                                   WEDNESDAY, SEPTEMBER 14, 2022

In this workshop, you will learn how to use range names in formulas and function 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 advance formulas and functions, Excel will save you time and reduce errors when conducting data analysis.

EXCEL: ORGANIZING WORKSHEET DATA WITH TABLES & CHARTS                          WEDNESDAY, SEPTEMBER 21, 2022

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 trend line and create advanced charts.

EXCEL: USING PIVOTTABLES, PIVOTCHARTS & GRAPHICS                               WEDNESDAY, SEPTEMBER 28, 2022

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: ENHANCING WORKBOOKS & CLASS PROJECT                                          WEDNESDAY, OCTOBER 5, 2022

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 "Bringing It All Together" class project to test all newly acquired skill sets.

*Qualifying companies can send employees for a discounted rate of $80 - includes all 4 sessions through the Employment Training Program (ETP) funded by the Employment Training Tax.

Private Companies More Info... or Government/Non Profit More Info...