Manchester Community College

Learn detailed instructions about how to use the Microsoft Office applications of Word, Excel, and PowerPoint, as well as how to integrate Word, Excel, and PowerPoint.  Applicable skills:

Demonstrate the fundamental skills needed to use the MS Word word-processing application. Create new Word documents, edit and format existing Word documents, add graphics and tables to Word documents, and merge Word documents.

Use the MS Excel spreadsheet application. Skillfully use the basic elements of Excel, create and use simple and complex formulas and functions, incorporate useful charts and graphs, add, delete, sort, and lay out table data.  

Create MS PowerPoint presentations. Explain the basic elements and fundamentals of Microsoft PowerPoint, insert objects and finish a presentation, work with PowerPoint tools, tables, and charts, apply Slide Master, shapes, and effects, and Insert hyperlinks, illustration objects, and media clips.

Learn the skills necessary to integrate an Excel spreadsheet into a Word document. Identify the tools used to integrate Word and Excel files, embed an Excel worksheet into a Word document, embed an Excel chart or graph into a Word document, explain the difference between object linking and embedding, describe the procedure for linking an object to a Word document, develop a form letter with form fields, and merge a database with a form letter.

Integrate a Word document and table, and Excel chart with a PowerPoint Presentation. Identify the tools used to integrate Word, Excel, and PowerPoint files, create PowerPoint presentations, place and manipulate clip art in a PowerPoint slide, work with themes and templates, add notes to a PowerPoint slide show, set the slide transitions for a PowerPoint slide show, embed and link Word and Excel material in PowerPoint presentations.

On average this course is 127 hours of independent, online instruction.

To complete this Microsoft Office certificate program, you will either need to buy Microsoft® Office 2019 or subscribe to Microsoft 365®. While Microsoft does offer a free trial of their programs through their site, it's important to note that the length of the trial period may not offer students enough time to complete the certificate program.

For more detailed information: Microsoft Office 2019 PROGRAM OUTLINE

This course is WIOA Approved.