.png)
Reviewing Data
Once all data has been written into Excel, you will want to review it before further posting and report generation.
This is done through the <Review Data> button.
Our Event Scoring Spreadsheet in the example below allows 1 mark per item. Should a field contain more than one mark we automatically flag this field with a red highlight.
.png)
The Review Data routine steps through all the records (top to bottom) and will automatically VIEW potentially problematic records.
.png)
Your job is to review the displayed image and if necessary make changes to the displayed data (in column 3, labeled 'Values').
When you have completed your review and possible editing, click <Done> to return and post your changes to the RECORDS worksheet.
.png){kind=small}
Any red highlights will be removed and the record will be marked with an "R" (for Reviewed) in the third column, just to the right of the link.
.png)
Click the <Review Data button> again to continue the review.
When all data has been reviewed you will see a message telling you so.
.png)
Next: Checking for Duplicates >>>