English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 0h 45m | 120 MB
If you work in Excel, you know that even a small error can have big consequences, throwing off important calculations or transmitting incorrect information to your team. In this concise course, Excel expert Dennis Taylor provides quick and easy tips to help you avoid common mistakes. Dennis begins with the basics—how to display data so that errors can be easily spotted, enter data correctly the first time, and apply shortcuts for frequent entries. Dennis provides easy ways to protect worksheets and validate your data—techniques that are particularly helpful when multiple team members are contributing to the same spreadsheet. He also shows how to correctly use row and column references and avoid mistakes in formulas.
Table of Contents
Introduction
1 Optimize your Excel skills
Data Entry and Design Tips
2 Reduce data entry and typing errors
3 Simplify and accelerate date and time entries
4 Shortcuts tips and techniques
Protect Worksheets and Workbooks
5 Lock cells with worksheet protection
6 Protect workbooks
Data Validation
7 Restrict data using validation constraints
8 Force cell contents to be picked from a list
Formula Tips
9 Use row and column references
10 Detect errors in formulas
Conclusion
11 Resources
Resolve the captcha to access the links!