MOS: Microsoft Office Specialist 2010

77-881: Microsoft Office Word 2010

• Getting Started With Word 2010
• Formatting and Working With Text in Word 2010
• Organizing and Arranging Text in Word 2010
• Moving Around In Word 2010
• Structuring Word 2010 Documents
• Reviewing Documents in Word 2010
• Saving, Sharing, and Printing In Word 2010
• Customizing the Behavior and Appearance of Word 2010
• Drawing and Inserting Graphics in Word 2010
• Using Themes, Backgrounds, Watermarks, and Quick Parts in Word 2010
• Adding Tables of Contents, Footnotes, Hyperlinks, and Bookmarks in Word 2010
• Forms, Fields, and Mail Merge In Word 2010
• Managing, Inspecting, and Recovering Word 2010 Documents
• Creating and Formatting Tables in Word 2010
• Manipulating Tables in Word 2010
• Embedding Charts and Tables into Word 2010

77-882: Microsoft Office Excel 2010

• Getting Started With Excel 2010
• Applying Basic Data Formatting In Excel 2010
• Moving and Getting Around In Excel 2010
• Moving Data and Modifying Worksheets in Excel 2010
• Saving, Sending, and Printing Excel 2010 Workbooks
• Using Conditional Formatting, Tables, and Sparklines in Excel 2010 
• Reviewing and Protecting Content in Excel 2010
• Using Basic Formulas in Excel 2010
• Using Basic Functions with Excel 2010
• Inserting Basic Charts in Excel 2010
• Adding Visuals, Themes, and Styles to Excel Workbooks
• Customising Visual Elements in Excel 2010
• Customising Workbook Settings, Conditional Formatting, and Number Formats
• Organising Data and Objects in Excel 2010
• Ensuring Excel 2010 Data and Formulas Are Right
• Automating Excel Tasks Using Macros
• Analysing Data with What-If Analysis
• Pivot tables and Pivot charts In Excel 2010
• Pivot table Filters, Calculations, And Power pivot

77-883: Microsoft Office PowerPoint 2010

• Getting Started With PowerPoint 2010
• Visually Enhancing PowerPoint 2010 Presentations
• Adding Images to Presentations in PowerPoint 2010
• Using Multimedia and Animations in PowerPoint 2010
• Using Advanced Slide Show Tools in PowerPoint 2010
• Collaborating and Sharing Presentations in PowerPoint 2010

77-884: Microsoft Office Outlook 2010

• Getting Started With Outlook 2010
• Managing Conversations and Organizing E-Mail in Outlook 2010
• Managing Attachments, Graphics, Signatures, And Auto replies In Outlook 2010
• Using the Calendar for Appointments, Events, and Meetings in Outlook 2010
• Managing Meetings and Customizing the Calendar in Outlook 2010
• Outlook 2010 Social Connector and Messaging
• Working With Contacts in Outlook 2010
• Using the Tasks, Notes, And Journal Features In Outlook 2010
• Formatting E-Mail and Configuring Message Options in Outlook 2010
• Customizing Outlook 2010 and Managing Accounts
• Managing E-Mail with Rules, Automatic Replies, and Alerts in Outlook 2010
• Working with File Transfer and Folders, Searching, and Ross Feeds Outlook 2010
• Data Files, Archiving, and Send/Receive Groups in Outlook 2010
• Implementing Security with Outlook 2010
• Accessing Exchange Remotely and Using Forms in Outlook 2010

77-885: Microsoft Office Access 2010

• Getting Started With Access 2010
• Creating Basic Tables in Access 2010
• Data Manipulation and Simple Relationships in Access 2010
• Modifying Basic Forms in Access 2010
• Introduction to Queries in Access 2010