MCSEClasses Certification Training Boot Camp MCSE MCSD MCDBA Cisco CIW Linux Oracle Java Security 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
  • 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 ]


    MCSEClasses.com 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.



    mcseclasses home | technical schedule | application schedule | class outlines | mcse, mcdba, mcsd training | microsoft .net | cisco certification | security training | ced solutions oracle® certification training | linux, unix, aix | comptia certification | webmaster training | pricing | locations | financing | instructors needed | e-mail us





    Search classes by keyword:


    Search classes by category:

    Copyright © 2019 CED Solutions. CED Solutions Refund Policy. All Rights Reserved.

    MCSE certification boot camps and courses are offered in these select cities: Albany MCSE, Albuquerque MCSE, Alexandria MCSE, Anchorage MCSE, Atlanta MCSE, Austin MCSE, Billings MCSE, Birmingham MCSE, Bismarck MCSE, Boise MCSE, Boston MCSE, Charleston MCSE, Charlotte MCSE, Cheyenne MCSE, Chicago MCSE, Cincinnati MCSE, Cleveland MCSE, Columbia MCSE, Columbus MCSE, Dallas MCSE, Denver MCSE, Des Moines MCSE, Detroit MCSE, Hartford MCSE, Honolulu MCSE, Houston MCSE, Indianapolis MCSE, Jackson MCSE, Kansas City MCSE, Las Cruces MCSE, Lincoln MCSE, Little Rock MCSE, Los Angeles MCSE, Louisville MCSE, Madison MCSE, Milwaukee MCSE, Minneapolis MCSE, Montpelier MCSE, New Orleans MCSE, New York City MCSE, Norfolk MCSE, Oklahoma City MCSE, Omaha MCSE, Philadelphia MCSE, Phoenix MCSE, Pierre MCSE, Pittsburgh MCSE, Portland MCSE, Princeton MCSE, Providence MCSE, Raleigh MCSE, Richmond MCSE, Sacramento MCSE, Salt Lake City MCSE, San Antonio MCSE, San Diego MCSE, San Francisco MCSE, San Jose MCSE, Seattle MCSE, Stamford MCSE, Tulsa MCSE, Washington MCSE, Wilmington MCSE.

    MCSE Canada Boot Camps : mcse Calgary, mcse Edmonton, mcse Halifax, mcse Hamilton, mcse Kitchener, mcse London, mcse Montreal, mcse Ottawa, mcse Quebec City, mcse Toronto, mcse Vancouver, mcse Winnipeg.

    CED Solutions offers MCSE certification boot camps and courses in the United States: MCSE Alabama, MCSE Alaska, MCSE Arizona, MCSE Arkansas, MCSE California, MCSE Colorado, MCSE Connecticut, MCSE District of Columbia, MCSE Delaware, MCSE Georgia, MCSE Hawaii, MCSE Idaho, MCSE Illinois, MCSE Indiana, MCSE Iowa, MCSE Kansas, MCSE Kentucky, MCSE Louisiana, MCSE Maine, MCSE Massachusetts, MCSE Michigan, MCSE Minnesota, MCSE Mississippi, MCSE Missouri, MCSE Montana, MCSE Nebraska, MCSE New Jersey, MCSE New Mexico, MCSE New York, MCSE North Carolina, MCSE North Dakota, MCSE Ohio, MCSE Oklahoma, MCSE Oregon, MCSE Pennsylvania, MCSE Rhode Island, MCSE South Carolina, MCSE South Dakota, MCSE Texas, MCSE Utah, MCSE Vermont, MCSE Virginia, MCSE Washington, MCSE West Virginia, MCSE Wisconsin, MCSE Wyoming.

    MCSE Canada Boot Camps : Alberta mcse, British Columbia mcse, Manitoba mcse, New Brunswick mcse, Newfoundland mcse, Nova Scotia mcse, Ontario mcse, Saskatchewan mcse. Quebec mcse.