Microsoft Office 2016 Certificate Classes

Program Outline

Instruction Sets
Your program consists of courses designed to take you step-by-step through the applications of Microsoft® Office 2016.

Here's how it works
Your first course will be sent immediately after your enrollment has been accepted. Other courses will follow as you complete your exams, so that you will always have materials to work with.

Computer Specifications
As you know this is an online academic program. This means you will need high-speed internet access to begin your program. In addition, you will need access to a Microsoft® Windows® based computer running Windows® 7 or later or an Apple® Mac® computer running OS X® or later, an email account, and Microsoft® Office 2016 to participate in and complete your program.

You will complete the following courses in the order indicated to earn your Microsoft® Office certificate.

Program Goal and Outcomes

Program Goal: To provide detailed instruction to students about how to use the Microsoft Office applications Word, Excel, and PowerPoint, as well as how to integrate Word, Excel, and PowerPoint.

Program Outcomes:
Upon completion of the program, students will be able to:

  • 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
  • Demonstrate the fundamental skills needed to 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
  • Demonstrate the fundamental skills needed to use MS PowerPoint presentation application
  • 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
  • Demonstrate 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
  • Demonstrate the skills necessary to 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

Course 1

CSC035 - Microsoft® Word™
Learn how to use Microsoft® Word™ to create, edit, and illustrate documents. Create, edit, format, and merge Word™ documents. Add graphics and tables.

Graded Project: Microsoft® Word™
This project gives you a chance to use your Word™ skills. Create four promotional documents for a company’s training event: a cover letter introducing the company, a facts sheet highlighting product features, a flier promoting the event, and a registration form.

Course 2

CSC040 - Microsoft® Excel®
In this course, you’ll learn about the most widely used spreadsheet program, Microsoft® Excel.® Excel® can perform numerical calculations and is also useful for non-numerical applications such as creating charts, organizing lists, accessing data, and automating tasks. Use the basic elements of Microsoft® Excel.® Add, delete, and sort data. Create and use formulas, charts, and graphs.

Graded Project: Microsoft® Excel®
This project gives you the chance to use your Excel® skills. Create a simple worksheet to calculate the cost of office supplies, and track their increase or decrease in cost over a two-month period. Graph the results.

Course 3

CSC045 - Microsoft® PowerPoint®
Microsoft® PowerPoint® is a powerful graphics presentation program for communicating ideas to an audience. Understand the basic elements and fundamentals of Microsoft® PowerPoint.® Apply Slide Master, shapes, and effects. Insert hyperlinks, illustration objects, and media clips. Work with advanced tools, tables, and charts.

Graded Project: Microsoft® PowerPoint®
You’ll complete a hands-on project where you will create a PowerPoint® presentation using text, charts, multimedia features, and custom animations.

Course 4

CSC050 - Integrating MS Office Applications
Your first lesson in integrating Office applications covers integrating Word™ and Excel.® Embed an Excel® worksheet, chart, or graph into a Word™ document. Link an object to a Word™ document. Develop a form letter with form fields, and merge a database with a form letter.

Your second lesson in integrating Office applications covers integrating Word,™ Excel,® and PowerPoint.® Create a PowerPoint® presentation with clipart. Embed and link Word™ and Excel® material in the presentation.

Graded Projects:

Microsoft® Word,™ Excel,® and PowerPoint® Project
You’ll complete a hands-on graded project where you’ll create a presentation on world hunger using design templates, add clipart and an Excel® pie chart, and save the presentation as a video.

Microsoft® Word™ and Excel® Project
You’ll complete a hands-on project where you’ll prepare letterhead for the ABC Engineering Company, you’ll write a memo to a client, and create and embed a worksheet into the memo.

 

Online Library and Librarian
Students in Penn Foster Career School have access to an online library for use during their studies. Students can use this library to do the required research in the courses they complete or can use it for general reference and links to valuable resources. The library contains helpful research assistance, articles, databases, books, and Web links. A librarian is available to answer questions on general research-related topics via email and to assist students in research activities during their studies with Penn Foster Career School International.

We reserve the right to change program content and materials when it becomes necessary.

Microsoft, Windows, PowerPoint, and Excel are trademarks of Microsoft Corporation registered in the United States of America and/or other jurisdictions.

IBM is a trademark of IBM Corporation registered in the United States of America and/or other jurisdictions.

Pentium is a trademark of Intel Corporation or its subsidiaries registered in the United States and other countries.