India

Microsoft Office 2010 Master Certification Training

Learn basic to advanced skills in Microsoft Word, Excel, PowerPoint, and Outlook 2010 while you prepare for Microsoft Office Specialist (MOS) certification.
Temecula, CA P.O. Box 760,, Temecula, CA 92593
(951) 9723600

Course at a Glance

Mode of learning : Online - Instructor Lead(LVC)

Domain / Subject : Business & Management

Function : General

Trainer name : Clair Dickinson, Elizabeth Ann Nofs

Duration : 300 Hours

Difficulty : Medium

Microsoft Office 2010 Master Certification Training

Learn basic to advanced skills in Microsoft Word, Excel, PowerPoint, and Outlook 2010 while you prepare for Microsoft Office Specialist (MOS) certification. You’ll discover how to create and format documents, how to use tables, how to complete a mail merge, and more! Certification can help you differentiate yourself in today’s competitive job market, broaden your employment opportunities, garner greater earning potential, and advance in your current job.

Objectives

Certification Exam 77-881: MOS: Microsoft Office Word 2010 OR 
Microsoft Certification Exam 77-887: MOS: Microsoft Office Word 2010 Expert

By completing the Microsoft Word 2010 Online Training Program, you’ll:

  • Know how to create and customize documents
  • Learn to format content and control pagination
  • Become skilled in formatting illustrations, graphics, text, and text boxes
  • Understand how to use Quick Parts to organize content, modify tables, and merge documents
  • Know how to insert, modify, and delete comments
  • Learn to share and secure documents
  • Apply, create, remove, and modify Styles on text, shapes, and pictures

Certification Exam 77-882: MOS: Microsoft Office Excel 2010 OR 
Microsoft Certification Exam 77-888: MOS: Microsoft Office Excel 2010 Expert

By completing the Microsoft Excel 2010 program, you’ll:

  • Be able to enter, copy, paste, and fill data and formulas
  • 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

Certification Exam 77-883: MOS: Microsoft Office PowerPoint 2010

By completing the Microsoft PowerPoint 2010 Online Training Program, you’ll:

  • Know how to create and customize presentations
  • Learn to format content
  • Become skilled in formatting illustrations, graphics, text, and text boxes
  • Apply Animation and Transitions
  • Know how to insert and modify multimedia
  • Learn to share and secure presentations
  • Apply, create, remove and modify Styles on text, shapes, and pictures

Certification Exam 77-884: MOS: Microsoft Office Outlook 2010 

By completing the Microsoft Outlook Online Training Program, you’ll:

  • Know how to create and customize messages
  • Learn to create, track, and respond to messages automatically
  • Organize the Inbox with Rules and Quick Steps
  • Record and schedule appointments in the calendar
  • Learn to create, track, and respond to meeting requests
  • Document Contacts and Tasks Journal Entries
  • Manage Outlook E-mail accounts, data files and backup

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: Word, Excel, PowerPoint, and Outlook.

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.

ed2go will provide the required textbooks for this program:

  • Beginning Guide to Microsoft® Word 2010
  • Intermediate Guide to Microsoft® Word 2010
  • Advanced Guide to Microsoft® Word 2010
  • Beginning Guide to Microsoft® Excel 2010
  • Intermediate Guide to Microsoft® Excel 2010
  • Advanced Guide to Microsoft® Excel 2010
  • Complete Guide to Microsoft® PowerPoint 2010
  • Complete Guide to Microsoft® Outlook 2010

Prerequisites

To enroll in the Microsoft Office 2010 Master Certification Training program, you should have basic computer skills and should be comfortable using an Internet browser and selecting commands from a menu or toolbar. You should be able to manage files, including saving, updating, and backing up files.

All of our programs are self-paced and open enrollment, so you can start them when you want and finish them at your own pace.

 

Course Syllabus

Beginning Microsoft Word

  • Getting Started: How to use the online course
  • Go Blue: Formatting Text
  • Horses and Zebras: Formatting Pictures
  • Mice and Men: Mouse options and tools
  • Fancy Colors: Picture Tools
  • First Prize: Shapes and SmartArt
  • First Impressions: Create Business Stationery
  • Intermediate Microsoft Word
  • Rain Washes Out Hamburg: Make a Newsletter
  • Open for Business: Building blocks and templates
  • The Guests Are Invited: Create a Mail Merge
  • Add Me to the List: Advanced Mail Merge and troubleshooting
  • Charlotte’s Web Site: Create a Web Page
  • Online All the Time: Word and the Internet

Advanced Microsoft Word

  • Table for Two: Advanced Table Functions
  • The Table is Set: Quick Tables and Quick Styles for Tables
  • Doing It With Style: Create Styles
  • Going in Style: Headers and Footers, and References
  • Who Done It? Create an On-Line Form
  • Prepare to Share: Proofing Tools and Tack Changes
  • Working with Macros: Create and use Macros

Beginning Guide to Microsoft Excel 2010

  • Getting Started: How to use the online course
  • Hello, Excel! Enter data and use basic text formatting
  • It All Adds Up: enter data, labels and formulas
  • A Question of Balance: Use and audit formulas from Excel’s formula library
  • Charts and Chart Tools: Insert and modify Charts
  • Picture the Data: Insert and format pictures
  • Shapes, SmartArt, Views: Insert and modify Shapes and SmartArt, change Views

Intermediate Guide to Microsoft Excel 2010

  • Legs, Eggs, and Pigs: Troubleshooting formulas and data
  • Piggy Goes to Market: Use and modify TEXT formulas
  • Name that Tune: Create, use and troubleshoot Named Ranges
  • Sound Advice: Create and use Lookup Tables, use IF functions
  • Excel In Print: Use page Layout and Page Set up to modify print settings
  • Excel Online: Use and modify Sparklines and hyperlinks

Advanced Guide to Microsoft Excel 2010

  • Works for Me! Create and modify Tables and apply Quick Styles
  • Work Smarter, Not Harder: Use Sort, Filter, Outline, and Goal Seeking Tools
  • What Happened? (Pivot Tables) Create and modify Pivot Tables
  • What Did You See (Pivot Charts) Create and modify Pivot Charts and Slicers
  • Working Overtime: Create drop-down lists and use Data Validation 
  • Prepare to Share: Use reviewing tools and permissions
  • Working with Macros: Create and use Macros

Beginning Microsoft PowerPoint

  • Getting Started: How to use the online course
  • P is for Paragraph: Entering text in presentations
  • Working with Text Boxes: Formatting Shapes and Themes
  • Picture, Picture: Formatting Pictures
  • Shapes and SmartArt: Formatting and Using SmartArt
  • Photo Albums and Views: Create a Photo Album

Advanced Microsoft PowerPoint

  • Tables and Spreadsheets: Adding and Using Tables
  • Charts and Chart Tools: Adding and Formatting Charts
  • Reach for the Starts: Slide Masters and Transitions
  • Top Ten Reasons: Apply Animations
  • Animating Multimedia: Adding and Formatting Videos
  • Show Time: Delivering Presentations
  • Prepare to Share: Proof and Protect Presentations
  • Online and in Print: Options for saving and sharing

Microsoft Outlook E-mail

  • Getting Started: How to use the online course
  • Hello, Outlook: Formatting Messages
  • Messages and Messengers: Message Options
  • From Me to You: Graphics, SmartArt and Attachments
  • Signed, Seal and Delivered: Organize the Inbox with Rules and Quicksteps
  • Contacts and Connections

Working with the Calendar

  • Eight Days a Week: Scheduling
  • Tasks and Time Management

Sharing, Collaboration and Management

  • Outlook Online
  • Outlook in Print
  • Advanced Options
  • The Administrator: E-mail Accounts, Setup, Backup

Photos

Write Your Own Review


Write your review here (required)


Consider:
Is the price of course overrated?
would you recommend this course to others?
Is duration of the course sufficient enough?
Did you like the faculties?
What would you prefer in future classroom or online learning?


Disclaimer: The contents of the course & Institute are obtained from the institute’s website by automated scraping or manual updates. For the latest information, please refer the institute website directly. For any discrepancies in the content, contact us at