Workforce Training

NJBIA Logo in black and tealThe NJBIA Basic Skills Workforce Training program is a partnership between the New Jersey Business & Industry Association (NJBIA), the New Jersey Community College Consortium for Workforce and Economic Development, and the NJ Department of Labor and Workforce Development.

These classes are Grant-funded training for employee participants, for a business or non-profit organization, registered in New Jersey, or maintains a business location in NJ.  

Classes take place online in a Zoom meeting. Computer skills classes require access to MS Office downloaded programs. Enrollment is limited; please register early. Participants MUST be registered before the first class day.

Registration Form
(1 Form Per Class)

Submit Registration Form:

Email: Linda Connor, CE Coordinator, at lconnor@sussex.edu
or
Mail: Sussex County Community College, One College Hill Road, Newton, NJ 07860 ATTN: Linda Connor, CE

 

Basic Skills Workforce Training Courses

Four 2-hour sessions, 8 hours total

Tuesday, September 27
Thursday, September 29
Tuesday, October 4
Thursday, October 6

9 am–11 am 

This class will introduce students to MS Excel basics including creating spreadsheets, formulas, functions, text, formatting, and graphics.  Students will be able to perform basic (introductory) level Excel skills such as modifying an existing worksheet, building worksheets, copying and moving cells, etc. 

Upon completion of this course students will be able to:

  • Use the Excel menu system and Excel toolbars
  • Use Excel task panes
  • Display help information
  • Modify an existing worksheet
  • Move the cell pointer and change data in the worksheet
  • Reverse an edit operation and save workbook
  • Add data to a worksheet
  • Enter a formula into a worksheet
  • Adjust column width in a worksheet
  • Adjust row height in a worksheet
  • Build a new worksheet
  • Edit a worksheet
  • Format a worksheet
  • Change the page setup for a worksheet
  • Insert a manual page break into a worksheet, including print titles in a printout

Use Basic Excel functions, i.e., Sum, Average, and Count

Four 2-hour sessions, 8 hours total

Tuesday, October 11
Thursday, October 13
Tuesday, October 18
Thursday, October 20

9 am–11 am

This class will reinforce the elements introduced in Excel Level I and expand upon that base to include more complex but necessary activities such as functions, charts, linking worksheets, adding pictures, and more.

Upon completion of this course students will be able to:

  • Find a specific entry in a worksheet
  • Use options in the past special dialog box
  • Use alignment options in the format cells dialog box
  • Use and understand absolute cell references
  • Use and understand logical functions
  • Use and understand financial functions
  • Use and understand date/time functions
  • Create a chart
  • Modify and enhance a chart
  • Work with a list, including sorting the records and specifying a range of values
  • Link worksheets within a workbook
  • Split the workbook window into panes and freezing window panes
  • Hid rows and columns of a worksheet
  • Add pictures and diagrams to worksheets
  • Use an Excel template to create a workbook
  • Insert a hyperlink into a worksheet using the research feature
  • Insert comments into a worksheet