Microsoft Office Specialist 2010

Microsoft Office Specialist: Word 2010

MOS 2010 Word

Sharing and Maintaining Documents

  • Apply different views to a document.
  • Apply protection to a document.
  • Manage document versions.
  • Share documents.
  • Save a Document.
  • Apply a template to a document.

Formatting Content

  • Apply font and paragraph attributes.
  • Navigate and search through a document.
  • Apply indentation and tab settings to paragraphs.
  • Apply spacing settings to text and paragraphs.
  • Create tables.
  • Manipulate tables in a document.
  • Apply bullets to a document.

Applying Page Layout and Reusable Content

  • Apply and manipulate page setup settings.
  • Apply themes.
  • Construct content in a document by using the Quick Parts tool.
  • Create and manipulate page backgrounds.
  • Create and modify headers and footers.

Including Illustrations and Graphics in a Document

  • Insert and format Pictures in a document.
  • Insert and format shapes, WordArt, and SmartArt.
  • Insert and format Clip Art.
  • Apply and manipulate text boxes.

Proofreading documents

  • Validate content by using spelling and grammar checking options
  • Configure AutoCorrect settings
  • Insert and modify comments in a document

Applying References and Hyperlinks

  • Apply a hyperlink.
  • Create Endnotes and Footnotes in a document.
  • Create a Table of Contents in a document.

Performing Mail Merge Operations

  • Setup mail merge
  • Execute mail merge

Microsoft Office Specialist: Excel 2010

MOS 2010 Excel

Managing the Worksheet Environment

  • Navigate through a worksheet.
  • Print a worksheet or workbook.
  • Personalize environment by using Backstage.

Creating Cell Data

  • Construct cell data.
  • Apply AutoFill.
  • Apply and manipulate hyperlinks.

Formatting Cells and Worksheets

  • Apply and modify cell formats.
  • Merge or split cells.
  • Create row and column titles.
  • Hide and unhide rows and columns.
  • Manipulate Page Setup options for worksheets.
  • Create and apply cell styles.

Managing Worksheets and Workbooks

  • Create and format worksheets.
  • Manipulate window views.
  • Manipulate workbook views.

Applying Formulas and Functions

  • Create formulas.
  • Enforce precedence.
  • Apply cell references in formulas.
  • Apply conditional logic in a formula.
  • Apply named ranges in formulas.
  • Apply cell ranges in formulas.

Presenting Data Visually

  • Create charts based on worksheet data.
  • Apply and manipulate illustrations.
  • Create and modify images by using the Image Editor.
  • Apply Sparklines.

Sharing worksheet data with other users

  • Share spreadsheets by using Backstage.
  • Manage comments.

Analyzing and Organizing Data

  • Filter data.
  • Sort data.
  • Apply conditional formatting.

Microsoft Office Specialist: PowerPoint 2010

MOS 2010 PowerPoint

Managing the PowerPoint Environment

  • Adjust views.
  • Manipulate the PowerPoint window.
  • Configure the Quick Access Toolbar.
  • Configure PowerPoint file options.

Creating a Slide Presentation

  • Construct and edit photo albums.
  • Apply slide size and orientation settings.
  • Add and remove slides.
  • Format slides.
  • Enter and format text.
  • Format text boxes.

Working with Graphical and Multimedia Elements

  • Manipulate graphical elements.
  • Manipulate images.
  • Modify WordArt and shapes.
  • Manipulate SmartArt.
  • Edit video and audio content.

Creating Charts and Tables

  • Construct and modify tables.
  • Insert and modify charts.
  • Apply chart elements.
  • Manipulate chart layouts.
  • Manipulate chart elements.

Applying Transitions and Animations

  • Apply built-in and custom animations.
  • Apply effect and path options.
  • Apply and modify transitions between slides.
  • Manipulate animations.

Collaborating on Presentations

  • Manage comments in presentations.
  • Apply proofing tools.

Preparing Presentations for Delivery

  • Save presentations.
  • Share presentations.
  • Print presentations.
  • Protect presentations.

Delivering Presentations

  • Apply presentation tools.
  • Set up slide shows.
  • Set presentation timing.
  • Record presentations.

Microsoft Office Specialist: Access 2010

MOS 2010 Access

Managing the Access Environment

  • Create and manage a database
  • Configure the Navigation Pane.
  • Apply Application Parts.

Building Tables

  • Create tables
  • Create and modify fields
  • Sort and filter records
  • Set relationships.
  • Import data from a single data file.

Building Forms

  • Create forms
  • Apply Form Design Tab options.
  • Apply Form Arrange Tab options.
  • Apply Form Format Tab options.

Creating and Managing Queries

  • Construct queries
  • Manage source tables and relationships
  • Manipulate fields
  • Calculate totals
  • Generate calculated fields.

Designing Reports

  • Create reports
  • Apply Report Design Tab options.
  • Apply Report Arrange Tab options
  • Apply Report Format Tab options.
  • Apply Report Page Setup Tab options.
  • Sort and filter records for reporting

Microsoft Office Specialist: Outlook 2010

MOS 2010 Outlook

Managing the Outlook Environment

  • Apply and manipulate Outlook program options.
  • Manipulate item tags.
  • Arrange the Content Pane.
  • Apply search and filter tools
  • Print an Outlook item.

Creating and Formatting Item Content

  • Create and send email messages.
  • Create and manage Quick Steps.
  • Create item content.
  • Format item content.
  • Attach content to email messages

Managing Email Messages

  • Clean up the mailbox.
  • Create and manage rules.
  • Manage junk mail.
  • Manage automatic message content.

Managing Contacts

  • Create and manipulate contacts.
  • Create and manipulate contact groups.

Managing Calendar Objects

  • Create and manipulate appointments and events.
  • Create and manipulate meeting requests.
  • Manipulate the Calendar pane.

Working with Tasks, Notes, and Journal Entries

  • Create and manipulate tasks
  • Create and manipulate notes.
  • Create and manipulate Journal entries.

Microsoft Office Specialist: Word Expert 2010

MOS 2010 Word Expert

Sharing and Maintaining Documents

  • Configure Word options.
  • Apply protection to a document.
  • Apply a template to a document.

Formatting Content

  • Apply advanced font and paragraph attributes.
  • Create tables and charts.
  • Construct reusable content in a document.
  • Link sections.

Tracking and Referencing Documents

  • Review, compare, and combine documents.
  • Create a reference page.
  • Create a Table of Authorities in a document.
  • Create an index in a document.

Performing Mail Merge Operations

  • Execute Mail Merge.
  • Create a Mail Merge by using other data sources.
  • Create labels and forms.

Managing Macros and Forms

  • Apply and manipulate macros.
  • Apply and manipulate macro options.
  • Create forms.
  • Manipulate forms.

Microsoft Office Specialist: Excel Expert 2010

MOS 2010 Excel Expert

Sharing and Maintaining Workbook

  • Apply workbook settings, properties, and data options.
  • Apply protection and sharing properties to workbooks and worksheets.
  • Maintain shared workbooks.

Applying Formulas and Functions

  • Audit formulas.
  • Manipulate formula options.
  • Perform data summary tasks.
  • Apply functions in formulas.

Presenting Data Visually

  • Apply advanced chart features.
  • Apply data analysis.
  • Apply and manipulate PivotTables
  • Apply and manipulate PivotCharts
  • Demonstrate how to use the slicer.

Working with Macros and Forms

  • Create and manipulate macros.
  • Insert and manipulate form controls.

Microsoft Office Specialist: Master

MOS Master 2010
  • Word Expert 2010
  • Excel® Expert2010
  • PowerPoint® 2010
  • Outlook® 2010
    Access® 2010