Can I use use Excel to track attendance?
By: POSGuys - 1/27/2016

<h1>How do you do attendance tracking with Excel?</h1>
<iframe width="560" height="315" src="https://www.youtube.com/embed/g9OcVCDpHns" frameborder="0" allowfullscreen></iframe>

Ideally when you're tracking attendance you are using an attendance tracking program or at least a database where you have user information in one table and scans in another, you can then cross like the tables together to validate and verify who it is that is coming in.

However if all you would like to do is get the information on whomever is coming in and not necessarily validate them, then you can use 2D barcodes which hold much more information than a regular 1D barcode which holds a simple string about 10 characters max.

In the displayed video we use Microsoft Access, Microsoft Excel, and a special ultra lite edition of <a href = "https://posguys.com/barcode-label-software_52/SeaGull-Bartender-Basic-Edition_63/">Seagull Bartender Basic</a> for the <a href = "https://posguys.com/barcode-printer_1/Honeywell-PC42t_2471/">Honeywell PC42t</a>.  There are other programs you could use instead and if you have a 2D Barcode Scanner with driver's license parsing then you can create a ruleset where between data fields it automatically sends a "TAB".

To test a 2D barcode without installing a label creation program you can use our <a href = "https://posguys.com/barcode/">FREE Barcode Generator</a> and setup using different barcodes and what information you want.

Can I use use Excel to track attendance? By: POSGuys - 1/27/2016

Recent Posts By POSGuys

Can I use use Excel to track attendance?
By: POSGuys - 1/27/2016