This one-day course teaches the basic functions and features of Excel. After an introduction to spreadsheet terminology and Excel’s window components, participants will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and save workbooks in various formats. Participants will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, participants will create and modify charts, and learn how to manage large workbooks.

Course Outline:

Unit 1: Getting started

Unit 2: Entering and editing data

Unit 3: Modifying a worksheet

Unit 4: Using functions

Unit 5: Formatting worksheets

Unit 6: Printing

Unit 7: Creating charts

Unit 8: Managing large workbooks

Learning Management System Users:  Please login into your Learning Management System account and navigate to “Now Enrolling” from the “Browse” drop-down menu.  Select the training you wish to register for and click “Enroll.” This will initiate the required approval process.   

External participants, can click here to complete the HR-1 Training Authorization Form. 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.

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

If you have any questions about the program or the registration process, you can reach a customer success representative by calling (609) 777-2225 or emailing CLIPTraining.Support@csc.nj.gov. 

A $20 administrative  fee will apply to learners who do not have Learning Management System (LMS) platform accounts.