Microsoft Excel 2010 Expert: 77-888 Certification Prep

Course ID

27330

Course Description

Demonstrate your expertise with Microsoft Office! Designed to help you practice and prepare for the 2010 Excel Expert Microsoft Office Specialist (MOS) exam, this all-in-one study guide features:
  • Full, objective-by-objective exam coverage
  • Easy-to-follow procedures and illustrations to review essential skills
  • Hands-on practice tasks to apply what you have learned; files included
  • Online pre-test to assess your readiness

Prerequisites

None

Audience

Expert-level Microsoft Office Excel 2010 users are able to efficiently and confidently use Excel 2010 software at the feature and functionality levels. Expert users are proficient with advanced formulas, functions, and data analysis tools. Expert users can manipulate data for analysis, presentation, and collaboration. In addition, expert users can manipulate Excel options to customize their environment to meet varying needs and enhance their productivity.

Course Content

    Sharing and Maintaining Workbooks
  • 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
  • Create and manipulate PivotTables
  • Create and manipulate PivotCharts

    Working with Macros and Forms
  • Create and manipulate macros
  • Insert and manipulate form controls

For More Information

For training inquiries, call 850-308-1376

or email us at eramos@gbsi.com

Course Details

Duration - 1 day
Price - $250.00 USD


(Discounts may apply. Call for more information.)

Course Actions

Schedule

Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.