Microsoft Excel 2010 Certification Training

With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Excel 2010 software.  You’ll cover basic through advanced topics, including formatting fonts, applying number formats, linking worksheets, creating a PivotTable, and more. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market.

By completing the Microsoft Excel 2010 program, you will:

  • Be able to enter, copy, paste, and fill data and formulas
  • Learn how to link worksheets, consolidate data, and calculate revenue from several worksheets
  • Understand how to use the PivotTable and PivotCharts to automatically format and analyze data
  • Know how to filter and outline data
  • Be able to use the VLookup and HLookup function
  • Save, send, and share workbooks
  • Insert and modify Charts, Sparklines, pictures, SmartArt, and shapes
  • Apply QuickStyles to Charts, pictures, SmartArt, and Tables
  • Create and modify a Table

Students who wish to prepare for Microsoft Certification Exam 77-882:  MOS: Microsoft Office Excel 2010 OR Microsoft Certification Exam 77-888: MOS: Microsoft Office Excel 2010 Expert will find beginning through advanced lessons that demonstrate these requires MOS topics.

Course type Online - Self Paced
Start dates TBD

Course Requirements

This program can only be taken on a PC. It is not compatible with a Mac. It is compatible with the Windows XP and later operating systems and IE 7 and later browsers. You need a high-speed Internet connection and e-mail account. You should also have the following full-retail version Microsoft Office 2010 Products already installed: Excel and Word.

It is recommended that you use the latest version of Internet Explorer in place of other Web browsers.

Adobe Flash Player and Adobe Acrobat Reader are required for this program.

Click here to download the Acrobat Reader.

Click here to download the Flash Player.

All materials for this program are available online.

 The following textbooks are available to download throughout the lessons:

  • Beginning Guide to Microsoft® Excel 2010
  • Intermediate Guide to Microsoft® Excel 2010
  • Advanced Guide to Microsoft® Excel 2010

To enroll in the Microsoft Excel 2010 Online Training Program, you should have basic computer skills, be comfortable using an Internet browser and selecting commands from a menu or toolbar, be proficient in file management (save, print, and back-up files), and be able to select, edit, and format text.

This program is for you if you’re an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Excel skills immediately.  This program is also suitable for you if you’re looking to learn about this software and expand your job possibilities.

Instructor Bio

Clair Dickinson has a B.S. in secondary English education from Eastern Michigan University. She currently works as an online course facilitator in a lab setting, working with students taking courses towards their high school diplomas. She also completed her Graduate Certificate in Educational Media and Technology through Eastern Michigan University Online, doing all of the work online.

She earned the Microsoft Office 2010 Master certification by passing the tests for Word, Excel, PowerPoint, and Outlook 2010. In addition, she has Microsoft Word 2003 Expert level certification. She has used every version of Office since 1995 and still enjoys finding new ways to use the software.

In her spare time, Clair writes short crime stories and chases after her young son.

Elizabeth Ann Nofs is the designer and developer of the Computer Mama guides. Her research on how men and women approach computer learning provided the foundation for the Comma Method of training, as well as The Computer Mama Show, a pilot produced with WFUM/TV28 (PBS), Flint, Michigan.

She’s the author of 44 books, including: The Computer Mama Guide to Computers (2001), The Comma Method of Computer Training (2003), The Comma Teachers Edition (2003), The Complete Computer Guide (2005), and the Complete Computer Guides for Microsoft Office 2007 and Office 2010 (MOS) certification training.

Elizabeth received her B.A. degree in biology from the University of Michigan, Ann Arbor.