Cert Prep: Excel 2010 Microsoft Office Specialist (77-882)

Become a Microsoft Office Specialist. Study to pass the MOS Excel 2010 certification exam with our training videos, free exercise files, and full-length practice test.

Become a Microsoft Office Specialist. Study to pass the MOS Excel 2010 certification exam. This course, created by Microsoft Certified Trainer Jennifer McBee, helps test-takers prepare for exam 77-882, which covers eight core objectives for Excel 2010: managing the worksheet environment, creating cell data, formatting cells and worksheets, managing worksheets and workbooks, applying formulas and functions, presenting data visually, sharing worksheet data with other users, and analyzing and organizing data.

Explore the MOS certification program, its cost, and its format and walk through each Excel certification objective in detail. Get hands-on experience with free downloadable practice files and take the challenges to test your skills. The course wraps with a full-length, 50-minute practice exam.

Introduction

• Welcome
• What you should know before watching this course
• Using the exercise files
• Using the challenges

1. Microsoft Office Specialist Exam Overview

• Compare the different Microsoft Office Specialist certifications
• Prepare for the exam
• Exam format and time allotment

2. Manage the Worksheet Environment

• Navigate through a worksheet
• Print a worksheet or workbook
• Insert headers and footers
• Save Excel files in different formats
• Update and remove workbook properties
• Challenge: Manage the worksheet environment
• Solution: Manage the worksheet environment

3. Create Cell Data

• Insert or append data
• Copy or move data
• Paste Special commands
• Apply AutoFill
• Apply and manipulate hyperlinks
• Challenge: Construct cell data
• Solution: Construct cell data

4. Format 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
• Challenge: Format cells and worksheets
• Solution: Format cells and worksheets

5. Manage Worksheets and Workbooks

• Create, delete, and hide worksheets
• Copy and move worksheets
• Split and arrange windows
• Manipulate workbook views
• Challenge: Manage worksheets and workbooks
• Solution: Manage worksheets and workbooks

6. Apply Formulas and Functions

• Create basic formulas
• Enforce precedence
• Apply cell references in formulas
• Apply conditional logic in formulas
• Create named ranges
• Use named ranges for navigation and in formulas
• Challenge: Apply formulas and functions
• Solution: Apply formulas and functions

7. Present Data Visually

• Create charts based on worksheet data
• Insert illustrations
• Modify illustrations
• Modify SmartArt
• Apply Sparklines
• Challenge: Present data visually
• Solution: Present data visually

8. Share Worksheet Data with Others

• Change file type
• Manage comments
• Challenge: Share worksheet data with others
• Solution: Share worksheet data with others

9. Analyze and Organize Data

• Apply conditional formatting
• Filter data
• Sort data
• Challenge: Analyze and organize data
• Solution: Analyze and organize data

10. Final Practice Exam

• Challenge: Full-length practice exam
• Solution: Full-length practice exam

Conclusion

• Next steps