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:

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

$49.00

Select a start date for your 0.25 course

EventDates

2023-01-26 11:00:00_2023-01-26 12:00:00
2023-02-17 14:00:00_2023-02-17 15:00:00
2023-03-13 11:00:00_2023-03-13 12:00:00
2023-04-04 11:00:00_2023-04-04 12:00:00
2023-04-26 11:00:00_2023-04-26 12:00:00
2023-05-18 14:00:00_2023-05-18 15:00:00
2023-06-12 14:00:00_2023-06-12 15:00:00

Clear

Questions About This Course?

Need Help Finding The Right Training Solution?

Our training advisors are here for you.