Ultimate Excel Course #6: Validating and Protecting Excel Data

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
9 Lessons (41m)
    • 1. Introduction

      2:58
    • 2. Validating the the Number of Characters

      2:21
    • 3. Creating Date Validation Rules

      2:21
    • 4. Drop Down Lists for Easy Data Entry

      4:41
    • 5. Dependent Lists to Break Up Large Lists

      5:23
    • 6. Custom Data Validation Messages

      6:44
    • 7. Encrypt a File from Unauthorised Access

      2:46
    • 8. Protect the Structure of a Workbook

      5:44
    • 9. Protect Elements of a Worksheet

      7:48