Online Excel 2010 MOS Training

Microsoft » Microsoft Excel

Only $49.95

ONLINE Excel 2010 MOS TRAINING FEATURES

  • Learn Excel 2010 MOS online with these interactive online Excel 2010 MOS courses.
  • Affordable Pricing (Only $49.95 for the complete series)
  • A full year to complete the Excel 2010 MOS courses
  • Retake the Excel 2010 MOS courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test
  • Excel 2010 MOS Series (22 hours)

1. Becoming Familiar with Excel

Time: 4 hours
This course provides an overview of Microsoft Excel 2010 to help prepare you for the Microsoft Office Specialist exam.

Objectives

  • This course provides an overview of Microsoft Excel 2010 to help prepare you for the Microsoft Office Specialist exam.
  • Use the Ribbon and toolbars
  • Create new workbooks
  • Open existing workbooks
  • Move around in workbooks
  • Save workbooks
  • Recover workbook backups

Topics

  • Learning the Excel Environment
  • New and Existing Workbooks
  • Moving Around a Workbook
  • Saving Workbooks
  • Checking Compatibility and Accessibility
  • Working More Efficiently
  • Recovering Workbooks and Updating Excel


2. Performing Basic Workbook Tasks

Time: 3 hours
This course provides information on basic tasks you perform when working with data in your worksheets to help prepare you for the Microsoft Office Specialist exam.

Objectives

  • This course provides information on basic tasks you perform when working with data in your worksheets to help prepare you for the Microsoft Office Specialist exam.
  • Select cells and cell ranges
  • Enter labels and values in a worksheet
  • Edit and clear cell contents
  • Copy, paste, and move data
  • Insert, delete, and replace cell contents
  • Use AutoCorrect and work with actions

Topics

  • Selecting Cells, Rows, and Columns
  • Entering Labels and Values
  • Editing and Clearing Cell Contents
  • Copying, Moving, and Pasting Content
  • Inserting, Deleting, and Replacing
  • Using AutoCorrect and Actions


3. Working with Formulas and Functions

Time: 4 hours
This course prepares you for the Excel MOS 77-882 exam by providing an introduction to using formulas and functions in Excel 2010. It also provides some tips for troubleshooting common errors with formulas and functions.

Objectives

  • This course prepares you for the Excel MOS 77-882 exam by providing an introduction to using formulas and functions in Excel 2010. It also provides some tips for troubleshooting common errors with formulas and functions.
  • Work with formulas
  • Name cells and ranges, and use cell references
  • Perform calculations
  • Locate and correct formula errors
  • Create and use functions

Topics

  • Working with Formulas
  • Editing Formulas and Using References
  • Naming Cell Ranges
  • Performing Calculations
  • Correcting Errors
  • Audits and Circular References
  • Creating Functions
  • Array Formulas and Nested Functions


4. Modifying Workbooks and Worksheets

Time: 3 hours
This course provides instruction on modifying the way information is organized, displayed, or hidden in Microsoft Excel 2010 workbooks and worksheets.

Objectives

  • Name, insert, delete, move, copy, and hide worksheets
  • Adjust column width and row height
  • Freeze columns and rows
  • Split worksheets
  • Save layouts
  • Use templates

Topics

  • Working with Excel Worksheets
  • Moving, Copying, and Hiding Worksheets
  • Selecting and Hiding Columns and Rows
  • Inserting and Deleting Columns and Rows
  • Adjusting Column Width and Row Height
  • Freezing and Splitting Worksheets
  • Creating Views and Saving Layouts
  • Using Templates


5. Formatting Worksheets

Time: 3 hours
This course provides tools and techniques that will allow you to effectively format your worksheets.

Objectives

  • Format numbers and text
  • Apply and manage conditional formatting
  • Add sparkline formatting
  • Adjust data alignment and text flow
  • Add color, borders, and themes
  • Apply Cell Styles

Topics

  • Formatting Numbers and Text
  • Applying Conditional Formatting
  • Managing Conditional Formatting
  • Adding Sparkline Formatting
  • Adjusting Data Alignment and Text Flow
  • Adding Color and Borders
  • Using Themes
  • Applying Cell Styles


6. Viewing and Printing

Time: 2 hours
This course explains how to print worksheets in Excel.

Objectives

  • Set up pages for printing
  • Adjust page margins, headers, and footers
  • Insert page breaks and customize print jobs
  • Preview and print worksheets
  • Create PDF and XPS documents

Topics

  • Setting Up Pages for Printing
  • Adjusting Page Margins
  • Adding Headers and Footers
  • Inserting Page Breaks
  • Customizing the Print Area
  • Previewing and Printing


7. Working with Graphics

Time: 3 hours
This course explains how to add visual flair to Excel worksheets with clip art, screen shots, WordArt, SmartArt and graphic shapes.

Objectives

  • Use clip art and media clips
  • Insert pictures and screen shots
  • Apply styles, shapes, and borders
  • Correct and recolor pictures
  • Create WordArt and SmartArt

Topics

  • Using Clip Art and Media Clips
  • Inserting Pictures and Screenshots
  • Applying Styles, Shapes, and Borders
  • Correcting and Recoloring Pictures
  • Adding Transparency
  • Creating WordArt Text
  • Building SmartArt Graphics
  • Drawing and Modifying Shapes



Resources for Excel 2010 MOS

Student Login



  1. Forgot My Password
  2. Support

Live eLearning

Like a class you would go to, but you don't have to go anywhere

More...

Try a Free Course

Click here to try a free course.

Partners & Resources
  1. View Partners & Resources
  2. Become a Partner
© Webucator, Inc. All rights reserved. | Toll Free: 877-932-8228 | UK: 0808-101-3484 | From outside the USA: 315-849-2724| Fax: 315-849-2723