Reviewing and Protecting Content in Excel 2013


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Excel 2013 provides tools that allow you to manage multiple workbooks as well review and protect them while creating and sharing content. You can consolidate data, control recalculation, merge and manage versions of a workbook. Excel also provides the track changes feature allowing you to track, accept, or reject changes. When reviewing comments, you can edit, add, or delete comments. In addition, the spell checker reviews the spelling and allows you to change, ignore, or add to the dictionary. Finally, Excel allows you to protect a range, worksheet, or workbook with a password. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Expected Duration (hours)
1.0

Lesson Objectives

Reviewing and Protecting Content in Excel 2013

  • consolidate data and merge workbooks in Excel 2013
  • decide how to consolidate data in Excel 2013
  • choose how to merge workbooks in Excel 2013
  • use Track Changes in Excel 2013
  • add and edit comments in Excel 2013
  • spell check a workbook in Excel 2013
  • decide how to use comments and track changes in Excel 2013
  • protect sheets and workbooks in Excel 2013
  • choose how to protect workbooks in Excel 2013
  • Course Number:
    mo_puel_b02_dt_enus

    Expertise Level
    Intermediate