Microsoft Office Specialist 2010

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

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.

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.

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

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.

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.

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.

• Word Expert 2010
• Excel® Expert2010
• PowerPoint® 2010
• Outlook® 2010
  OR
  Access® 2010