Did you know that two-thirds of all middle-skill job openings require proficiency in productivity software such as Microsoft® Word,™ Excel,® and PowerPoint®?¹ Penn Foster Career School’s Microsoft® Office 2016 training can help you gain the knowledge and skills needed to improve your Microsoft® Office skills in a variety of work environments.² You’ll learn how to use Microsoft® Word,™ Excel,® and PowerPoint,® as well as how to integrate Microsoft® Office applications.
Penn Foster Career School’s Microsoft® Office 2016 Certificate program will help you learn essential skills through hands-on practice using Office applications. Plus, you will learn at home on your own time, and at a pace that’s right for you. And, you can complete this program in just two months!
Program Goal and Outcomes
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.
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
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.
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.
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.
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.
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.
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.
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.
To view a Microsoft® Office 2016 sample lesson, click here.
Microsoft® Office 2016 Program Details
In the Penn Foster Career School Microsoft® Office 2016 training program, you will gain a working knowledge of the following programs:
- Integrating MS Office Applications
State Licensing Information
Licensing and/or certification requirements for jobs in this field are not the same in every state and may include educational, testing, and/or experiential requirements beyond those offered by your Penn Foster Program. You should contact the state professional licensing board or similar regulatory body in the state(s) where you plan to work to determine their requirements before enrolling in your Program. Please click here for contact information for state licensing/regulatory boards and certain industry licensing information.