NJBIA III - Basic Skills Training Course Descriptions
Introduction to Word 2007 - Level 1: This class will introduce participants to the basic operations of Microsoft Word at the beginning level.
Upon completion of the training, student/participants will be able to:
- Create a document
- Enter text into a document and save a document
- Examine a document’s properties & print a document
- Close a file
- Edit a document
- Reopen a file
- Move the insertion point within a document & select text
- Insert text into a document & delete text from a document
- Find text in a document
- Find and replace text in a document & move a text block
- Display a document in full-screen mode
- Apply attributes to text, apply a new font and font size to text
- Indent a paragraph & format existing text
- Reset line and paragraph spacing in a document
- Reset the margins of a document
- Set and clear tab stops in a document
- Create a bulleted/numbered list
- Insert a hard page break & create a multiple-page document
- Use the spelling and grammar checker & use the thesaurus
- Use a Word template to create a document
- Print an envelope and a label
- Preview and save a document as a Web page
- Insert symbols and special characters into a document
Registration
Note: Municipal employees (city, county state or federal), schools and colleges are not eligible for this training program.
- To use our online registration form, click here.
Introduction to Word 2007 - Level 2: This class will continue where Level 1 finishes and introduce participants to additional operations of Microsoft Word.
Upon completion of the training student/participants will be able to:
- Find and replace formatting
- Add special effects to text
- Enter hidden text into a document
- Adjust character spacing in a document
- Create a multiple-section document
- Reveal and clear formatting in a document
- Insert a table in a document
- Format a table
- Insert and delete rows/columns in a table
- Convert text to a table
- Create parallel columns in a document
- Create newsletter-style columns in a document
- Insert a chart into a document
- Insert a diagram into a document
- Use styles
- Set up an outline document
- Produce a report
- Add a border and shade to text
- Add a header/footer to a document
- Add page numbers to a document
- Print specific pages of a document
- Insert a picture into a document
- Insert a hyperlink into a document
- Split the document window/open a new document window
Registration
Note: Municipal employees (city, county state or federal), schools and colleges are not eligible for this training program.
- To use our online registration form, click here.
Introduction to Excel 2007 - Level 1: This class will introduce students to Excel basics including creating spreadsheets, formulas, functions, text, formatting & graphics.
Upon completion of the training student/participants will be able to:
- Use the Excel menu system & use Excel toolbars
- Exit from Excel
- Modify an existing worksheet
- Move the cell pointer & change data in a worksheet
- Reverse an edit operation & save a workbook
- Add data to a worksheet
- Enter a formula into a worksheet
- Make adjustments to a worksheet: i.e. column width, cell height, row height
- Printing a worksheet
- Build a new worksheet
- Open a new workbook
- Edit a worksheet
- Select ranges in a worksheet
- Use autofill & autosum
- Copy cells, move cells & clear cells
- Insert and delete rows and columns
- Insert and delete a range of cells
- Format a worksheet
- Change the page setup for a worksheet
- Preview a worksheet
- Print selected worksheet entries
- Use Excel functions: sum, average & count
Registration
Note: Municipal employees (city, county state or federal), schools and colleges are not eligible for this training program.
- To use our online registration form, click here.
Introduction to Excel 2007 - Level 2: This class will introduce students to Excel basics including creating spreadsheets, formulas, functions, text, formatting & graphics.
Upon completion of the training student/participants will be able to:
- Find and replace a specific entry in a worksheet
- Create a new style/apply a style
- Use options in the paste special dialog box
- use alignment options in the format cells dialog box
- Enter an absolute column and absolute row cell reference into a formula
- Enter an absolute column or absolute row cell reference into a formula
- Use the IF function, nesting IF functions
- Use the PMT function, using the FV function
- Use the DATE function, using the NOW function
- What is a chart ?, plot a chart
- Modify and enhance a chart
- Preview and print a chart
- Include non-contiguous data ranges in a chart
- What is a list?, sort the records of a list
- Filter the records of a list
- Specify a range of values as criteria for a filter operation
- Rename worksheets in a workbook
- Move the cell pointer from one worksheet to another
- Insert and delete worksheets
- Enter a formula to link related worksheets in a workbook
- Format multiple worksheets in one operation
- Preview and print multiple worksheets in one operation
- Split the workbook window into panes, freeze window panes
- Hide rows and columns of a worksheet
- Open a new workbook / arrange open workbook windows
- Change the zoom level of a worksheet
- Insert a picture into a worksheet
- Insert a diagram into a worksheet
- Use an Excel template to create a workbook
- Apply a background to a worksheet
- Hide an entire worksheet and an entire workbook
- Preview and save Excel data as a Web page
- Insert a hyperlink into a worksheet, use the research feature
- Insert comments into a worksheet
Registration
Note: Municipal employees (city, county state or federal), schools and colleges are not eligible for this training program.
- To use our online registration form, click here.
Communications - Written Skills : This course 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 limits itself to written skills only.
Upon completion of the training, participants will:
- Organize information and present complete thoughts
- Understand the basic rules of grammar (written and verbal)
- Understand the important 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
Registration
Note: Municipal employees (city, county state or federal), schools and colleges are not eligible for this training program.
- To use our online registration form, click here.
Communications for Improved Customer Service: This course is designed for those workers who come into contact with the customers of any company. Customers are defined as anyone, external paying customers or staff who support the company’s mission. The course will help the participants better understand who their customers are and the benefits for both the individual worker and the company in providing good customer service.
Upon completion of the training, participants will:
- Define customer service
- Be able to explain the difference between external and internal customers
- Recognize that service delivery is an individual response value
- Understand how your own behavior impacts the behavior of others
- Develop more confidence and skill as a problem-solver
- Communicate more assertively and effectively
- Learn some ways to make customer service a team approach
- Look at the impression they give customers and ways they can improve
- Focus on communication barriers and how we can overcome them
- Master the seven steps to improved customer service
Registration
Note: Municipal employees (city, county state or federal), schools and colleges are not eligible for this training program.
- To use our online registration form, click here.