Programming & Development

Excel - Trace and Defend your Data

Introduction:

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.

Objectives:

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

Course Outline:

Enroll in this course

$49.00

Need Help Finding The Right Training Solution?

Our training advisors are here for you.