Resources – Data Capture
Recommended links
Data capture

VBA in Excel
Life is so much simpler when you automate, all my data collection is done via VBA for collection and transforming data into information. This 6 hour course gives you a good base and you can download their free excel spreadsheets to work through and refer back to. As in the ‘7 Habits’ this is a Win : Win.
MS Access
A long course but well worth the time investment, this was a great refresher for me so I could design the user interfaces on our production lines to collect data as operators worked.