Excel - Follow, Trace and Defend your Data

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT

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.

 

Upcoming Class Dates and Times

Aug 29, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Oct 04, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Nov 08, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Dec 15, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR

Agenda

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