Workforce Training

Six 2 hours sessions (12 hours)

Tuesday, May 3
Thursday, May 5
Tuesday, May 10
Thursday, May 12
Tuesday, May 17
Thursday, May 19

9 am- 11am

This course is designed for those workers who have basic verbal and reading skills in English. It will demonstrate how different personal communication styles affect how co-workers, supervisors, and customers receive and interpret information. The course will target the outcomes as defined below but limit itself to written skills only. Upon completion of the training students will be able to:

• Organize information and present complete thoughts.
• Understand the basic rules of grammar (written and verbal).
• Understand the importance of ‘tone’.
• Avoid repetitive use of words and redundancies.
• Avoid jargon, slang, and clichés.
• Avoid excessive wordiness and negative language
• Understand the importance of proper spelling and punctuation.
• Be able to prepare a short and properly constructed written business letter or memo.

Four 2-hour sessions ~ 8 hours

Monday, April 25
Wednesday, April 27
Monday, May 2
Wednesday, May 4

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

Monday, May 9
Wednesday, May 11
Monday, May 16
Wednesday, May 18

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