These Hands-on Workshops in MS Office Suite are grant-funded through the New Jersey Community College Consortium
The Industry-Business Institute offers grant-funded computer skills workshops through a grant from the NJDOLWD in cooperation with the New Jersey Community College Consortium for Workforce and Economic Development. Businesses and non-profit agencies (non-government) are eligible to participate. Our mobile computer lab allows us to bring training to the client’s premises for 10 or more employees per class. Open enrollment classes are held on our college campuses for those with fewer than 10 to train. With questions regarding open enrollment classes contact Denise Petrosky at 908-965-2359. To arrange a session at your business, please contact Nancy Burke at 908-527-7207 or Denise at 908-965-2359.
MS Access Level 1 (8 hours)
Learn the basic operations of the Microsoft Access database program to perform day-to-day responsibilities and become more productive at work. Fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications are covered.
MS Excel Part 1 (8 hours)
You will create and edit basic MS Excel worksheets and workbooks. Create a basic worksheet by using MS Excel; perform calculations in an Excel worksheet; modify an Excel worksheet; format a worksheet; print the content of an Excel workbook
MS Excel Part 2 (8 hours)
You will organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects in MS Excel. Use advanced formulas; organize worksheet and table data using various techniques; create and modify charts; analyze data using PivotTables, Slicers, and PivotCharts; insert and modify graphic objects in a worksheet; and customize and enhance workbooks and the MS Excel environment.
MS Excel Level 3 (8 hours)
Further build on the skills acquired in the Basic and Intermediate courses. Work with advanced functions and formulas, lookup functions such as VLOOKUP, MATCH, and INDEX. Learn about data validation, and advanced data filtering, apply advanced chart formatting options, and create more complex charts. Work with PivotTables and PivotCharts, export and import data, and query external databases. The analytical features of Excel, such as Goal Seek, and how to create scenarios
MS Outlook (8 hours)
You will use MS Outlook to compose and send email, schedule appointments and meetings, manage contact information, schedule tasks and create notes.
PowerPoint (8 hours)
You will learn to create and save presentations and slides, add shapes and objects to slides, use tables and charts in presentations and use templates and themes. Word Art, Clip Art, inserting and adjusting pictures, slide shows, transitions and timing, speaker notes, running and printing presentations are also covered.
MS Word Part 1 (8 hours)
Create a basic Word document; edit a document; format text; format paragraphs; insert a table; insert special characters and graphical objects; control the page setup and appearance of a Word document; and proofread documents for accuracy using MS Word.
MS Word Part 2 (8 hours)
Using MS Word you will manage lists; customize tables and charts; customize the formatting of a document using styles and themes; modify pictures in a document; create customized graphic elements; insert content using Quick Parts; control text flow; use templates to automate document creation; use the mail merge function and use macros to automate common tasks.
Windows O/S (8 Hours)
You will log on to Windows, explore its interface, identify the different components in the interface, customize the Windows Desktop, manage files and folders, use the common tools and programs available in Windows, and browse the Internet