George Mason University, Volgenau School of Engineering

TAIT 0226: Microsoft Office Specialist (MOS)

Overview

This certificate program provides hands on training on Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft Outlook and Microsoft PowerPoint 2010. Participants are taught the subject matter in a hands on approach and guided to prepare for the certification exam.

Earning a Microsoft Office Specialist certification can help you differentiate yourself in today's competitive job market and broaden your employment opportunities by displaying your advanced skills Microsoft Office Specialist certification.

For employers , the certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system.


Audience and Prerequisites

There are no prerequisites for the Microsoft Office Specialist certificate program. Students may have experience using the internet.

Course Outline Detail

Microsoft Word 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

Excel 2010
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

PowerPoint 2010

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

Outlook 2010

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

Access 2010

Managing the Access  Environment

  • Create and manage a database
  • Configure the Navigation Pane
  • Apply Application Parts
  • 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
 
Registration

Click here to download the registration form (fax or mail)

Schedule

Please call for our upcoming class schedule

Tuition

$2,500

CEUs
12.0 CEUs
120 Hours
Onsite Opportunity

Enhance your organization's competitive edge!

George Mason University's TechAdvance Program can tailor programs to meet your organization's needs. Companies or agencies interested in bringing this program on site should contact TechAdvance at 703-993-1551.

Contact Info.
Online contact form
Address:

  George Mason University
TechAdvance
Volgenau School of Engineering
  4400 University Drive, MS 4A3
  Fairfax, VA 22030

Telephone: 703-993-1551
Email: advance@gmu.edu
Volgenau School of Engineering George Mason University