Excel - Trace and Defend your Data


This session is designed to teach you how to prevent errors in a worksheet. You will learn how to use tools to evaluate formulas, encrypt data with passwords and prevent unwanted changes.


Course Outline:

1 – Outline

  • Determine which cells are used in a formula and if a cell is used in a formula
  • Show all formulas on a worksheet, evaluate a formula, add a watch window and apply data validation
  • Create drop-down lists to restrict data entry to a date. Add and remove a password to a workbook
  • Add protection to an entire worksheet protect cells, worksheets, and workbooks

Enroll in this course


Need Help Finding The Right Training Solution?

Our training advisors are here for you.

USD United States (US) dollar