Microsoft® Office 2019 Certificate Program Details

Penn Foster’s Online Microsoft® Office 2019 Certificate Program consists of courses that will cover the basics of Microsoft® Word™, Excel®, and PowerPoint®. You’ll also learn how to integrate Office applications, including Word,™ Excel®, and PowerPoint®. To complete this program, you will either need to buy Microsoft® Office or subscribe to Microsoft 365®.

Program Goal and Outcomes

Program Goal

The goal of this program is to provide detailed instruction to students about how to use 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 Microsoft® 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 Microsoft® Excel® spreadsheet application
  • Create an Excel® spreadsheet; apply design and formatting to make worksheet data easier to understand; produce calculations using formulas and functions; incorporate useful charts and graphs; add, delete, sort, and lay out table data
  • Demonstrate the fundamental skills needed to use Microsoft® PowerPoint® presentation application
  • Explain the basic elements and fundamentals of Microsoft® PowerPoint®; create a presentation; develop presentations with slide transitions, animations, graphics, and media files; work with PowerPoint® tools, tables, and charts; apply Slide Master; and insert hyperlinks.
  • 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 an 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, and create a photo album slideshow.

Study how to use Microsoft® Word™ to create, edit, and illustrate documents.

Objectives:

  • Identify how to create various Microsoft® Word™ documents
  • Write a sound Microsoft® Word™ letter
Graded Project: Microsoft® Word™

This project gives you a chance to use your Word™ skills. Create literature for a Welcome Package: a cover letter, a facts sheet, a flier promoting a wellness clinic, and a pre-registration form.

This course covers 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.

Objectives:

  • Identify how to create various Microsoft® Excel® documents
  • Produce a thorough Microsoft® Excel® spreadsheet
Graded Project: Microsoft® Excel®

This project gives you the chance to use your Excel® skills. Create a simple worksheet to calculate the cost of elementary school supplies and track their usage over a two-month period.

Microsoft® PowerPoint® is a powerful graphics presentation program for communicating ideas to an audience.

Objectives:

  • Identify the basic skills needed to use Microsoft® PowerPoint®
  • Create a visually engaging PowerPoint® presentation
Graded Project: Microsoft® PowerPoint®

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

Your first lesson in integrating Office applications covers integrating Word™ and Excel.®

Objectives:

  • Create integrated Office documents using Word™ and Excel®
  • Prepare a spreadsheet and a Word™ document for a prospective client

Your second lesson in integrating Office applications covers integrating Word,™ Excel,® and PowerPoint.®

Objectives:

  • Add to a PowerPoint® presentation using Word™, Excel®, and other data
  • Create a PowerPoint® presentation, including an outline, video file presentation, table of statistics, and a spreadsheet
Graded Projects

Microsoft® Word™ and Excel®, and PowerPoint®:

You’ll complete a hands-on graded project where you’ll create a presentation on hunger in the local community using an outline, a table of statistics, a spreadsheet with statistics, and a chart.

Additional Details

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 in the Penn Foster Program. Prospective students should contact the state professional licensing board or similar regulatory body in the state(s) where they plan to work to determine their requirements before enrolling in this Program. Click here for contact information for state licensing/regulatory boards and certain industry licensing information.
Please review your state board requirements that are applicable to your field of study. State boards may impose a variety of different requirements.

Penn Foster Career School Accreditation & Licensing Details

Penn Foster has been accredited for over 50 years. Penn Foster Career School has been thoroughly reviewed and has earned several important accreditations, certifications, and licensing. Most importantly, Penn Foster Career School is both regionally and nationally accredited.

DEAC
MSA
Short Lessons
Easy-to-Access Lessons
Each lesson is broken into short chapters that allow you to fit learning into whatever time you have available. Don’t have time to finish a lesson? Not a problem - pick up where you left off next time!
Digital Flashcards
Digital Flashcards
A fun and interactive way to test your knowledge before your exams. Find out what information you've mastered, and what material needs additional review.
Penn Foster Sample Lesson

Sample Microsoft® Office 2019 Lesson

Penn Foster courses are written in a way that is easy to understand, and materials are broken down into manageable lessons. Take a look at what a Microsoft® Office 2019 course would look like.
Computer Specifications
As you know this is an online academic program. This means you will need access to high-speed internet to begin your program. In addition, you will need access to a Microsoft® Windows® based computer running Windows® 10 or later or an Apple® Mac® computer running macOS® or later, Microsoft® Office 2019 or Microsoft 365®, and an email account to complete this program.
Students must also have access to Microsoft® Excel® to complete this program.
We reserve the right to change program content and materials when it becomes necessary.
Microsoft and Windows are trademarks of Microsoft Corporation registered in the United States of America and/or other jurisdictions.
Apple, Mac, and OS X are trademarks of Apple, Inc. registered in the United States of America and/or other jurisdictions.
Enroll Now Request Info