articles of Excel office 2010 (2)

Excel 2010 that you will be "new" some impressions of it, that our view is not much nonsense, straight to the point, you can introduce two practical skills used in daily life.
We work in the actual form will be encountered such a problem: it is in the process of data entry form will inevitably go wrong, accidentally entered some wrong data, such as duplicate ISBN ISBN, out of range of valid data . In fact, as long as a reasonable set of data validation rules, you can avoid these errors and reduce losses.Example One: reject duplicate data entry
Book's ISBN number, ID number of people of various documents are unique and should not be repeated, if the duplicate entry in Excel, ID, will give information of query and maintenance to bring a lot of inconvenience, we can set office 2010 Excel  to data validation, duplicate data will be shut out.
Running Excel 2010, switch to the "data" area, select the required input data column, click the "Data Validation" button, pop-up "data validation" window.
Switch to the "Settings" tab, and lay the "Allow" drop-down box, select "Custom" in the "formula" field enter the = countif (a: a, a1) = 1.
Switch to the "Error Alert" tab, select the style of an error error warning message, fill in the title and error message, and finally click "OK" button to complete the data validation settings.
Thus, in setting off this column, enter the book's ISBN number and other information, duplication of information when the input, Excel immediately pops up an error warning that we entered incorrectly.
At this time, simply click the "Cancel" to close the message box prompted to re-enter the correct data on it.Example two: moving rapidly to identify invalid data
What is "invalid data" mean? We deal with Excel data, some data in practical applications there is a limit, such as the time of the data that must be somewhere between 0:00 to 23:59, the data, the data are outside this range invalid data, is not legitimate. If the use of "human flesh search", is no different needle in a haystack, where I recommend to use Microsoft office 2007 download Excel  "data validation" function, moving rapidly to identify invalid data in the table.

Excel 2010 opens with a need to review the Excel spreadsheet, select the area you want to audit, switch to the "data" area, click the Data Validation button, pop-up data validation window, switch to the "Settings" tab, Open the "Allow" drop-down box, select the "time", open the "Data" drop-down box, select "between", the minimum value is set to 0:00, the maximum is set to 23:59, and then OK.

Set the "rules of the game", select "Data Tools" area "data validation" drop-down menu of the "Circle Invalid Data."