Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

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

via LinkedIn Learning

Go to class Write review

Details

Go to class

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Duration & workload

4-5 hours
Sessions

On-Demand

Found in

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

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.

Syllabus

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

Taught by

Jennifer McBee

Reviews

Start your review of Cert Prep: Excel 2010 Microsoft Office Specialist (77-882)