MCSEClasses Certification Training Boot Camp Cisco Certification Training Military Discounts Testimonials About Us Linux/Unix Certification MCSD Certification Home MCSE Certification MCDBA Certification Cisco Certification Security Certification Java Certification Oracle® Certification CIW Certification Jobs Boot Camp Financing Boot Camp Pricing Boot Camp Technical Schedule Contact Us


Microsoft Office Specialist 2010 (MOS)

Course Length: 12 days
Certifications: MOS
Number of Exams: 4

Class Schedule
Call for Class Schedule

  • Includes roundtrip airfare and lodging (for boot camps held in Georgia)
  • Hands-on instruction by a certified instructor
  • Includes all course materials
  • On-site Testing
  • Lunch & Snacks provided each day

Earning a Microsoft Office Specialist certification can help you differentiate yourself in today's competitive job market, broaden your employment opportunities by displaying your advanced skills, and result in higher earning potential. Microsoft Office Specialist certification can also lead to increased job satisfaction. Research indicates that certified individuals have increased competence, productivity, and credibility with their employers, co-workers, and clients.

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.

Microsoft Office Specialist certifications are primarily for office workers who use Microsoft Office programs as a vital part of their job functions. This 12 day boot camp covers certification for Word 2010, PowerPoint 2010, Excel 2010, and Access 2010.  The course begins with Word training, exam prep, and the certification exam.  It is followed by Excel 2010, Access 2010, and PowerPoint 2010.

A Microsoft Office Specialist (MOS) certification helps validate proficiency in using Microsoft Office 2010 and meets the demand for the most up-to-date skills on the latest Microsoft technologies. Candidates who pass a certification exam show that they can meet globally recognized performance standards.

Microsoft Word 2010 - Introduction

This course is for students who want to learn to use the most widely used features of Microsoft Word 2010. It will provide a good foundation before getting into more advanced features.

Upon successful completion of this course, students will be able to:

  • create and edit a Word document.
  • format text and paragraphs.
  • insert a table.
  • insert special characters and graphical objects.
  • control the page setup and appearance of a Word document.
  • proofread documents for accuracy.

Course Content

Lesson 1: Creating a Word Document
Lesson 2: Editing a Word Document
Lesson 3: Formatting Text in a Word Document
  • Change Font Styles
  • Highlight Text in a Document
Lesson 4: Formatting Paragraphs in a Word Document
  • Set Tabs to Align Text
  • Modify the Layout of a Paragraph
  • Create Lists
  • Apply Borders and Shading
  • Apply Styles
  • Manage Formatting
Lesson 5: Inserting Tables in a Word Document
  • Create a Table
  • Modify a Table
  • Format a Table
  • Convert Text to a Table
Lesson 6: Inserting Special Characters and Graphical Objects
  • Insert Symbols and Special Characters
  • Insert Illustrations in a Document
Lesson 7: Controlling the Appearance of the Pages in a Word Document
  • Control the Layout of a Page
  • Apply a Page Border and Color
  • Add Watermarks
  • Add Headers and Footers
Lesson 8: Proofreading a Word Document
  • Check Spelling and Grammar
  • Use the Thesaurus
  • Customize the AutoCorrect Options

[ back to top ]

Microsoft Word 2010 - Intermediate

This course is for people that need to know how to create or modify complex business documents and customized Word efficiency tools.

Upon successful completion of this course, students will be able to:

  • manage lists.
  • customize tables and charts.
  • customize the formatting of a document using styles and themes.
  • modify pictures in a document.
  • create customized graphic elements.
  • insert content using Quick Parts.
  • control text flow.
  • use templates to automate document creation.
  • use the mail merge function.
  • use macros to automate common tasks.

Course Content

Lesson 1: Managing Lists
  • Sort, Renumber, and Customize a List
Lesson 2: Customizing Tables and Charts
  • Sort Table Data
  • Control Cell Layout
  • Perform Calculations in a Table
  • Create Charts
Lesson 3: Creating Customized Formats with Styles and Themes
  • Create or Modify a Text Style
  • Create a Custom List or Table Style
  • Apply Default and Customized Document Themes
Lesson 4: Modifying Pictures
  • Resize a Picture
  • Adjust the Picture Appearance Settings
  • Wrap Text Around a Picture
  • Insert and Format Screenshots in a Document
Lesson 5: Creating Customized Graphic Elements
  • Create Text Boxes and Pull Quotes
  • Draw Shapes
  • Add WordArt and Other Special Effects to Text
  • Create Complex Illustrations with SmartArt
Lesson 6: Inserting Content Using Quick Parts
  • Insert Building Blocks
  • Create Building Blocks
  • Modify Building Blocks
  • Insert Fields Using Quick Parts
Lesson 7: Controlling Text Flow
  • Control Paragraph Flow
  • Insert Section Breaks
  • Insert Columns
  • Link Text Boxes to Control Text Flow
Lesson 8: Using Templates to Automate Document Creation
  • Create a Document Based on a Template
  • Create a Template
Lesson 9: Automating the Mail Merge
  • Use the Mail Merge Feature
  • Merge Envelopes and Labels
  • Create a Data Source Using Word
Lesson 10: Using Macros to Automate Tasks
  • Automate Tasks Using Macros
  • Create a Macro

[ back to top ]

Microsoft Word 2010 - Advanced

Upon successful completion of this course, students will be able to:

  • use Word with other programs.
  • collaborate on documents.
  • manage document versions.
  • add reference marks and notes.
  • simplify the use of long documents.
  • secure a document.
  • create forms.

Course Content

Lesson 1: Using Microsoft Office Word 2010 with Other Programs
  • Link a Word Document to an Excel Worksheet
  • Send a Document Outline to Microsoft® Office PowerPoint®
  • Send a Document as an Email Message
Lesson 2: Collaborating on Documents
  • Modify User Information
  • Send a Document for Review
  • Compare Document Changes
  • Merge Document Changes
  • Review Track Changes and Comments
  • Coauthor a Document
Lesson 3: Managing Document Versions
  • Create a New Document Version
  • Compare and Merge Document Versions
Lesson 4: Adding Reference Marks and Notes
  • Insert Bookmarks
  • Insert Footnotes and Endnotes
  • Add Captions, Hyperlinks, and Cross-References
  • Add Citations and a Bibliography
Lesson 5: Simplifying the Use of Long Documents
  • Insert Blank and Cover Pages
  • Insert an Index
  • Table of Figures, Authorities, and Contents
  • Create a Master Document
Lesson 6: Securing a Document
  • Hide Text
  • Remove Personal Information from a Document
  • Set Formatting and Editing Restrictions
  • Add a Digital Signature to a Document
  • Set a Password for a Document
  • Restrict Document Access
Lesson 7: Creating Forms
  • Add Form Fields to a Document
  • Protect and Automate a Form

[ back to top ]

Microsoft PowerPoint 2010 - Introduction

This course is designed for students who are interested in learning the features needed to create and modify presentations.

Upon successful completion of this course, students will be able to:

  • create a presentation.
  • format text on slides.
  • add and modify graphical objects to a presentation.
  • work with tables in a presentation.
  • import charts to a presentation.
  • prepare to deliver a presentation.

Course Content

Lesson 1: Getting Started with PowerPoint
Lesson 2: Creating a Basic Presentation
  • Initiate a Presentation
  • Enter and Arrange Text
  • Format Text Placeholders
  • Add Slides to a Presentation
  • Arrange Slides
  • Work with Themes
Lesson 3: Formatting Text on Slides
  • Apply Character Formats
  • Format Paragraphs
Lesson 4: Adding Graphical Objects to a Presentation
  • Insert Images and Add Shapes to a Presentation
  • Add Visual Styles to Text in a Presentation
Lesson 5: Modifying Graphical Objects in Presentations
  • Edit Graphical Objects on a Slide
  • Format Graphical Objects on a Slide
  • Group and Arrange Graphical Objects on a Slide
  • Apply an Animation Effect to a Graphical Object
Lesson 6: Working with Tables
  • Insert and Format a Table in a Slide
  • Import Tables from Other Office Applications
Lesson 7: Working with Charts
  • Insert and Modify a Chart
  • Import Charts from Other Office Applications
Lesson 8: Preparing to Deliver a Presentation
  • Divide a Presentation into Sections
  • Add Transitions and Speaker Notes
  • Print a Presentation
  • Deliver a Presentation

[ back to top ]

Microsoft PowerPoint 2010 - Advanced

This course is designed for students with PowerPoint experience that are interested in advanced features.

Upon successful completion of this course, students will be able to:

  • customize the PowerPoint environment.
  • customize a design template.
  • add SmartArt graphics to a presentation.
  • add special effects to a presentation.
  • customize a slide show.
  • collaborate on a presentation.
  • secure and distribute a presentation.

Course Content

Lesson 1: Customizing the PowerPoint Environment
  • Customize the PowerPoint Interface
  • Set Options for Working with PowerPoint
Lesson 2: Customizing a Design Template
  • Set Up a Slide Master
  • Create Custom Slide Layouts
  • Add Headers and Footers
  • Modify the Notes Master
  • Modify the Handout Master
Lesson 3: Adding SmartArt Graphics to a Presentation
  • Insert SmartArt Graphics
  • Modify SmartArt Graphics
Lesson 4: Adding Special Effects to a Presentation
  • Add Multimedia Elements
  • Customize Slide Component Animations
Lesson 5: Customizing a Slide Show
  • Set Up a Custom Slide Show
  • Annotate a Presentation
  • Create a Presenter-Independent Slide Show
  • Set Up a Slide Show to Repeat Automatically
Lesson 6: Collaborating on a Presentation
  • Review a Presentation
  • Publish Slides to a Slide Library
  • Restrict Access to a Shared Presentation
  • Share a Presentation Using PowerPoint Web App
Lesson 7: Securing and Distributing a Presentation
  • Broadcast a Presentation
  • Convert a Presentation into a Video
  • Package a Presentation
  • Publish a Presentation to Other File Formats
  • Secure a Presentation

[ back to top ]

Microsoft Excel 2010 - Introduction

This course is designed for students who desire to gain the necessary skills to create, edit, format, work with formulas, and print Microsoft Office Excel 2010 worksheets.

Upon successful completion of this course, students will be able to:

  • create a basic worksheet by using Microsoft Office Excel 2010.
  • perform calculations in an Excel worksheet.
  • modify an Excel worksheet.
  • format a worksheet.
  • print the content of an Excel workbook.
  • manage an Excel workbook.

Course Content

Lesson 1: Creating a Basic Excel Worksheet
  • Identify the Elements of the User Interface
  • Customize the Excel Interface
  • Work with Cells
  • Enter Data in an Excel Workbook
  • Obtain Help in Excel
Lesson 2: Performing Calculations in an Excel Worksheet
  • Create Basic Formulas
  • Calculate the Cell Values by Using Functions
  • Copy Formulas and Functions
Lesson 3: Modifying an Excel Worksheet
  • Manipulate Data
  • Modify the Worksheet Elements
  • Search for Data in a Worksheet
  • Modify Rows and Columns
Lesson 4: Formatting an Excel Worksheet
  • Modify Fonts
  • Check a Worksheet for Spelling Errors
  • Apply Number Formatting
  • Add Borders and Colors to Cells
  • Align the Content in a Cell
  • Apply Cell Styles
Lesson 5: Printing Excel Workbooks
  • Set the Page Layout Options
  • Set Page Breaks
  • Print a Workbook
Lesson 6: Managing an Excel Workbook
  • Format Worksheet Tabs
  • Manage Worksheets
  • View Worksheets and Workbooks

[ back to top ]

Microsoft Excel 2010 - Intermediate

This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.

Upon successful completion of this course, students will be able to:

  • use advanced formulas.
  • organize worksheet and table data using various techniques.
  • create and modify charts.
  • analyze data using PivotTables, Slicers, and PivotCharts.
  • insert and modify graphic objects in a worksheet.
  • customize and enhance workbooks and the Microsoft Office Excel environment.

Course Content

Lesson 1: Calculating Data with Advanced Formulas
  • Apply Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data
  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Data
  • Use Functions to Calculate Data
Lesson 3: Presenting Data Using Charts
  • Create a Chart
  • Modify Charts
  • Format Charts
Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic Objects
  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects
Lesson 6: Customizing and Enhancing the Excel Environment
  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates

[ back to top ]

Microsoft Excel 2010 - Advanced

Upon successful completion of this course, students will be able to:

  • enhance productivity and efficiency by streamlining the workflow.
  • collaborate with other workbook users.
  • audit worksheets.
  • analyze data.
  • work with multiple workbooks.
  • import and export data.
  • integrate Excel data with the web.

Course Content

Lesson 1: Streamlining Workflow
  • Update Workbook Properties
  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria
Lesson 2: Collaborating with Other Users
  • Protect Files and Sharing a Workbook
  • Set Revision Tracking & Review Tracked Revisions
  • Merge Workbooks
  • Administer Digital Signatures
  • Restrict Document Access
Lesson 3: Auditing Worksheets
  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline
Lesson 4: Analyzing Data
  • Create Trendlines, Sparklines, and Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links
Lesson 6: Importing and Exporting Data
Lesson 7: Integrating Excel Data with the Web
  • Publish a Worksheet to the Web
  • Import Data from the Web
  • Create a Web Query
Lesson 8: Structuring Workbooks with XML

[ back to top ]

Microsoft Access 2010 - Introduction

This course is for students interested in designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. It is a foundation for more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications.

Upon successful completion of this course, students will be able to:

  • identify the components of a database.
  • organize and view data in tables.
  • query a database.
  • design forms.
  • generate reports.

Course Content

Lesson 1: Getting Started with Access 2010
  • Identify the Elements of the User Interface
  • Identify the Tabs and Commands on the Ribbon
Lesson 2: Identifying the Components of a Database
  • Database Concepts and Components of a Database
  • Examine the Relational Database Design Process
Lesson 3: Organizing Data in Tables
  • Create a Table
  • Modify Table Data and Properties
  • Create a Table Relationship
Lesson 4: Viewing Data in Tables
  • Sort Records
  • Filter Records
  • View Data from Related Tables
Lesson 5: Querying a Database
  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping
Lesson 6: Designing Forms
  • Create a Form
  • View Data Using an Access Form
  • Modify a Form
Lesson 7: Generating Reports
  • View an Access Report
  • Create a Report
  • Add a Calculated Field to a Report
  • Format the Controls in a Report
  • Apply a Theme to a Report
  • Prepare a Report for Print

[ back to top ]

Microsoft Access 2010 - Intermediate

This course is designed for individuals who wish to learn to work with revising intermediate-level queries, forms, and reports. It also introduces them to integrating Access data with other applications such as Microsoft Office Word or Excel.

Upon successful completion of this course, students will be able to:

  • streamline data entry and maintain data integrity.
  • join tables to retrieve data from unrelated tables.
  • create flexible queries to display specified records.
  • improve forms.
  • customize reports to organize the displayed information and produce print layouts.
  • share data between Access and other applications.

Course Content

Lesson 1: Controlling Data Entry
  • Constrain Data Entry Using Field Properties
  • Establish Data Entry Formats for Entering Field Values
  • Create a List of Values for a Field
Lesson 2: Joining Tables
  • Create Query Joins
  • Join Tables with No Common Fields
  • Relate Data Within a Table
Lesson 3: Creating Flexible Queries
  • Set the Select Query Properties
  • Retrieve Records Based on Input Criteria
  • Create Action Queries
Lesson 4: Improving Forms
  • Restrict Data Entry in Forms
  • Organize Information with Tab Pages
  • Add a Command Button to a Form
  • Create a Subform
  • Display a Summary of Data in a Form
  • Change the Display of Data Conditionally
Lesson 5: Customizing Reports
  • Organize Report Information
  • Format Reports
  • Control Report Pagination
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report
Lesson 6: Sharing Data Across Applications
  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge

[ back to top ]


IPLearning.net is your best choice for Microsoft MOS, Microsoft MOS training, Microsoft MOS certification, Microsoft MOS certification boot camp, Microsoft MOS boot camp, Microsoft MOS certification training, Microsoft MOS boot camp training, Microsoft MOS boot camp certification, Microsoft MOS certification course, Microsoft MOS course, training Microsoft MOS, certification Microsoft MOS, boot camp Microsoft MOS, certification Microsoft MOS boot camp, certification Microsoft MOS training, boot camp Microsoft MOS training, certification Microsoft MOS course.




Search classes by keyword:


Search classes by category:

Copyright © 2018 Institute of Professional Learning. IPL Refund Policy. All Rights Reserved.