MOS Boot Camp – MS Excel 2010

Microsoft Office Specialist certification gives you the tools to build a brighter future.

• Achieve industry-recognized certification
• Learn the computing skills companies are looking for
• Boost your workforce resume
• Differentiate yourself from other applicants
• Gain valuable experience and confidence
• Heighten your earning potential
• Prepare yourself for a successful future

The Core-level Microsoft Office Excel 2010 User should be able to navigate Microsoft Office Excel 2010 software at the feature and functionality level. They should be familiar with and know how to use at least 80% of the features and capabilities of Microsoft Office Excel 2010. The core?level user should be able to use Microsoft Office Excel 2010 to create and edit professional-looking spreadsheets for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life. Some of the roles users might take on include, but are not limited to:

• Clerical, Office professionals
• Consultants
• Executives/Managers
• Help desk personnel
• Instructors/Trainers
• Marketing personnel
• Product developers
• Sales
• Students
• Writers
• Other members of the general population

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