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:
 

Cost per Person: $159   

Pre- Requisite: Microsoft Excel Basic

Length: 6 hours

Time: 8:30am - 4:00pm

Course Description

This one-day course builds on the skills and concepts taught in Excel Basic. Participants will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, backgrounds, and watermarks. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and tables. Participants will save workbooks as Web pages, insert and edit hyperlinks, and save a workbook as a PDF file. This course also covers advanced charting techniques, worksheet auditing and protection, file sharing and merging, and workbook templates.

 
 
Course Topics

Unit 1: Using multiple worksheets and workbooks

Unit 2: Advanced formatting

Unit 3: Outlining and subtotals

Unit 4: Cell and range names

Unit 5: Lists and tables

Unit 6: Web and Internet features

Unit 7: Advanced charting

Unit 8: Documenting and auditing

Unit 9: Templates and settings

 
 
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