Workbook Protection and Change Tracking

DESCRIPTION: Protecting changes to a published file is critical. Excel by nature allows anyone and everyone to input data. Unfortunately, not everyone knows how to maintain data integrity. Cells that aren’t meant to be filled out get altered, columns or rows are accidentally deleted, important text is changed without permission, as well as many other cases. By protecting and limiting the options of your users or those whom you will share your workbook with, you are guaranteeing that any analysis, calculations, or text is protecting from unwanted changes. This course will show you the difference between workbook and worksheet protection, cell locking, file sharing, change tracking and finally how to approve/reject any changes or modifications.

TARGET AUDIENCE: This was designed for anyone who works in teams where data needs to be shared but also controlled

DOWNLOADABLE FILES: 

 

DIFFICULTY: Intermediate

COURSE OUTCOMES:

  • Protecting Sheets
  • Protecting Workbooks
  • Cell Locking
  • Password protecting cells
  • Sharing Files
  • Tracking Changes
  • Approving/Rejecting changes