text only siteskip to main contentskip to main navigation
 
State of New Jersey, Civil Service Commission
Governor Phil Murphy • Lt.Governor Sheila Oliver
 
 

Scheduled Date:
Email CLIPTraining.Support@csc.nj.gov or contact the Registration Team at 609-777-2225 to be added to the waitlist.

 

Location:
Mercer County Community College
1200 Old Trenton Rd
West Windsor, NJ 08550

Cost per Person: $159

Pre- Requisite: Microsoft Excel Intermediate

Length: 6 hours

Time: 8:30am - 4:00pm

 

Course Description

This one-day course builds on the skills and concepts taught in Excel Intermediate. Participants will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, participants will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, participants will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.

 
 
Course Topics

Unit 1: Advanced functions

Unit 2: Lookups and data tables

Unit 3: Advanced list management

Unit 4: PivotTables and PivotCharts

Unit 5: Exporting and importing

Unit 6: Analytical options

Unit 7: Macros and custom functions

Unit 8: Conditional formatting and SmartArt

 
 
Registration

Please complete the HR-1 Training Authorization Form to request classroom training. Your direct supervisor, departmental training coordinator and fiscal officer must approve the form. HR-1's received without proper approval will be returned to the Department's Training Coordinator.

You are not scheduled for the requested classroom training until you receive an official email confirmation from CLIP.

Fax your form to 609-777-2336. For any questions, please call the Registration Team at 609-777-2225.

 

Training Authorization Form

 

 

 

 

 

 
 
OPRA - Open Public Records Act NJ Home Logo
Department: CSC Home  |  Job Seekers  |  Current Employees  |  Appointing Authorities and Employers  |  About Us
Statewide: NJHome  |  Services A to Z  |  Departments/Agencies  |  FAQs
 
Copyright © State of New Jersey, 1996 - 2011