Overview
-
Prevent common errors from occurring in your Excel data with this short course.
Syllabus
-
Introduction
- Optimize your Excel skills
- Reduce data entry and typing errors
- Simplify and accelerate date and time entries
- Shortcuts, tips, and techniques
- Lock cells with worksheet protection
- Protect workbooks
- Restrict data using validation constraints
- Force cell contents to be picked from a list
- Use row and column references
- Detect errors in formulas
- Resources
