Online Microsoft Office 2010 Training | Penn Foster Career School

Online Microsoft® Office 2010 Certificate

Why Penn Foster Career School?

  • Regionally & Nationally Accredited
  • Self-Paced
  • Supportive
  • Low monthly payments

Program Overview

Did you know that Microsoft® Office ranks second on the list of most required skills for the jobs expected to have the highest growth and wages between now and 2020, and also ranks third across all occupations?¹ Penn Foster Career School’s Microsoft® Office 2010 Certificate Training Program will help you improve your computer application skills in a variety of office work environments.² You’ll learn how to use Microsoft® Word,™ Excel,® and PowerPoint,® as well as how to integrate Microsoft® Office applications.

Your program includes projects that give you the chance to get hands-on training using Office applications. You 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!

Curriculum Details

Program Goal and Outcomes

Program Goal

To provide a review of PC and Internet basics as well as 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:

  • Comprehend computer and information literacy 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
  • Demonstrate the fundamental skills needed to use the MS Excel spreadsheet application
  • 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
  • Create a PowerPoint presentation, work with PowerPoint tools, tables, and charts, apply Slide Master, shapes, and effects to a presentation, insert hyperlinks, illustration objects, and media clips
  • Identify the tools used to integrate Word and Excel files
  • Demonstrate the skills necessary to integrate an Excel spreadsheet into a Word document
  • Identify the tools used to integrate Word, Excel, and PowerPoint files
  • Demonstrate the skills necessary to integrate a Word document and table, and Excel chart with a PowerPoint Presentation

Course 1

CSC005 PC Basics

It’s difficult to imagine a world without computers, they’re such an integral part of our lives. In this lesson, you’ll build your knowledge of personal computers.


  • Understand the components of a personal computer, its navigation, and the Windows® operating system.
  • Use Windows,® browsers, email, search engines, Internet resources, and social networking, as well as security and privacy.

Course 2

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 3

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 4

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 5

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®

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.

You will need high-speed internet access to begin your program. You will need access to a Microsoft® Windows® based computer running Windows XP® SP3 or later, Microsoft® Office 2010, and an email account to complete your program with Penn Foster.

We reserve the right to change program content and materials when it becomes necessary.
Microsoft, Windows, Windows XP, PowerPoint, and Excel are registered trademarks and Word is a trademark of Microsoft Corporation registered in the United States of America and/or other jurisdictions.

Sample Lesson

To view a Microsoft® Office sample lesson, click here.

Microsoft® Office 2010 Program Details

In the Penn Foster Career School Microsoft® Office 2010 training program, you will gain a working knowledge of the following:

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.

Microsoft Office 2010 Certification

You can improve your skills in Microsoft® Office 2010 to help you prepare to take the next step for your career. Here are a few qualities that effective PC users have in common:

  • Analytical: It’s important to have a sharp eye and check things twice.
  • Problem solving: You enjoy crunching numbers and critically thinking to solve a problem.
  • Detail oriented: You make decisions and finish work on your own.
  • Persistent: You make decisions and finish work on your own.

I would encourage everyone to take a program through Penn Foster. I took my program hoping to learn a little bit, but I learned a lot!! I see myself taking more programs in the future!

- Donna L., Penn Foster Graduate

Penn Foster is an excellent distance learning school that prepares the student well for the work world. It helped me! Thanks Penn Foster!

- Victor C., Penn Foster Graduate

I really liked that the Penn Foster programs are so systematic. Each lesson builds on what you have learned and it all works together. I also liked the feeling of being part of a class, even though I did all the classes online. Thank you, Penn Foster for being there for me. I am proud of myself for graduating.

- Miriam S., Penn Foster Graduate

Your program includes:

  • Customized payment plans with 0% interest
  • Learning aids
  • Goal-setting and progress-tracking tools
  • Instructional support from our experienced faculty
  • Access 24/7 to Penn Foster’s online community, plus immediate membership in the Microsoft® Office 2010 Certificate academic group
  • Your personalized online student homepage and learning portal
  • Additional resources such as our online library and career guidance from Career Cruising

What will I get when I finish this certificate program?

When you complete the Microsoft® Office 2010 Certificate Program, you will receive a certificate of completion from Penn Foster Career School.

More FAQs >

¹ Download White Paper PDF

² The completion of a certificate-level program does not typically qualify a student for employment. Completion of this program may assist students who have previous academic or work related experience improve their chances for promotion or entry-level employment.

Find us on Google+