Forum Discussion
Tips for Quicker Data Entry?
Hi Hathyam,
Unfortunately this data is hard copy, but I am only inputting present or absent present as a ‘1’ and absent as a ‘0’. Ideally I was hoping there would be some way that I could simply type in their ‘student ID Numbers’ continuously, and excel would find the corresponding row, and input in a 1’ for that date.
I a 1 isn’t present then I fill in the 0’s later, which isn’t too much of a problem. It’s just putting 1’s in randomly through a list of 2-400 people is quite time consuming.
Presently I use find to find the student ID, and then manually click and enter a ‘1’ into the cell.
Certainly, the numbers of attendees will be more than absentees!
So I suggest that you assume that they are all present, and then you identify the absentees!
You can fill them all with 1 with simple operations like copy and paste, or you can use the https://support.office.com/en-us/article/display-or-hide-the-fill-handle-80918200-9ae9-4615-93c9-13d4f1496f81!
After that find the absentees and mark them.
In addition, I advise you to use this hidden https://www.youtube.com/watch?v=6cc7lUDLrXE, which is helpful to speed the data entry process!