These are Hands-on Workshops in MS Office Suite and include practice exercises and student manuals.
To schedule a session for your business or group, please contact Katrina James-Pellam. Group pricing available.
The Industry-Business Institute offers computer skills workshops. Our mobile computer lab or our Canvas distance learning platform allows us to bring training directly to your workforce. Open enrollment classes for individual registrations are listed in our Continuing Education catalog. Questions regarding open enrollment classes contact Continuing Education at 908-709-7600.
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.
MS 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
MS Office 365 (Cloud-based Computing) (8 hours)
This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of the Microsoft Office 2010, 2013, or 2016 edition of the Microsoft Office productivity suite, and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment.