Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Preventing Data Input Errors In Excel Using Data Validation Rules

K2 Enterprises
5.08K subscribers
<__slot-el>
<__slot-el>
4.4K views 11 years ago
Spreadsheet errors remain a major problem for those relying on Excel-generated reports and analyses. These errors can manifest themselves in many ways, including incorrect use of Excel functions, improper cell references, and data input errors. Fortunately, you can use Excel's Data Validation tool to minimize the opportunity for incorrect data input and in this tip you will learn how to work with Data Validation rules. ...more
...more
Preventing Data Input Errors In Excel Using Data Validation Rules
5Likes
4,441Views
2013Sep 13
Spreadsheet errors remain a major problem for those relying on Excel-generated reports and analyses. These errors can manifest themselves in many ways, including incorrect use of Excel functions, improper cell references, and data input errors. Fortunately, you can use Excel's Data Validation tool to minimize the opportunity for incorrect data input and in this tip you will learn how to work with Data Validation rules.

Follow along using the transcript.

K2 Enterprises

5.08K subscribers