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

LinkedIn Learning

Cert Prep: Excel 2013 Microsoft Office Specialist (77-420)

via LinkedIn Learning


Prep for the MOS Excel 2013 certification exam. Review worksheets and workbooks, cells and ranges, formulas and functions, charts, and other objects. Take the practice test.

Demonstrate your knowledge of Excel by becoming a Microsoft Office Specialist. Study to pass the MOS Excel 2013 certification exam. This course, created by Microsoft Certified Trainer Jennifer McBee, helps test takers prepare for exam 77-420, which covers the five main skills on the MOS Excel 2013 exam: creating worksheets and workbooks, cells and ranges, formulas and functions, and charts and other objects. Disclaimer: Microsoft does not produce, provide, or endorse this video training course.

The course first explores the MOS certification program, its cost, and its format. Jennifer then walks through all of the Excel certification objectives in detail. She includes free practice files so you can follow along as she demonstrates each skill. There are challenges to test your skills at the end of almost every chapter, and the full-length, 50-minute practice exam at the end of the course will ensure you're ready for the real exam.


  • 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 registration process
2. Create and Manage Workbooks and Worksheets
  • Create new workbooks
  • Add, copy, and move worksheets
  • Use hyperlinks to navigate workbooks
  • Use named ranges in navigation and formulas
  • Use Find and Replace for conditional formatting and data validation
  • Format using styles or themes
  • Format using the Page Layout ribbon
  • Insert headers and footers into worksheets
  • Insert columns and rows; hide and unhide data
  • Configure worksheets and workbooks for printing
  • Add values to workbook properties
  • Challenge: Worksheets and workbooks
  • Solution: Worksheets and workbooks
3. Create and Modify Cells and Ranges
  • Use Append to insert data into cells
  • Move data between cells, worksheets, and workbooks
  • Format worksheets using merge, cell styles, and number formats
  • Resize cells to accommodate text
  • Format cells using merge and align options
  • Apply conditional formatting
  • Create and use named ranges
  • Use Find and Replace
  • Challenge: Cells and ranges
  • Solution: Cells and ranges
4. Create and Modify Tables
  • Create tables
  • Modify tables
  • Filter and sort tables
  • Challenge: Create and modify tables
  • Solution: Create and modify tables
5. Apply Formulas and Functions
  • Use relative and absolute references in formulas
  • Understand the order of operations in formulas
  • Summarize data using functions
  • Utilize conditional logic in functions
  • Format with text functions
  • Challenge: Formulas and functions
  • Solution: Formulas and functions
6. Create Charts and Objects
  • Create charts and add data series
  • Format charts
  • Insert and format graphic objects
  • Challenge: Charts and objects
  • Solution: Charts and objects
7. Final Practice Exam
  • Challenge: Full-length practice exam
  • Solution: Full-length practice exam
  • Next steps

Taught by

Jennifer McBee

Related Courses


Start your review of Cert Prep: Excel 2013 Microsoft Office Specialist (77-420)

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free