Excel 2016: Avoiding Common Mistakes

Prevent common errors from occurring in your Excel data with this short course.

Introduction

• Optimize your Excel skills

1. Data Entry and Design Tips

• Reduce data entry and typing errors
• Simplify and accelerate date and time entries
• Shortcuts, tips, and techniques

2. Protect Worksheets and Workbooks

• Lock cells with worksheet protection
• Protect workbooks

3. Data Validation

• Restrict data using validation constraints
• Force cell contents to be picked from a list

4. Formula Tips

• Use row and column references
• Detect errors in formulas

Conclusion

• Resources