Resources – Data Capture

Recommended links

Data capture

statistic-gcfe520d2d_1920

VBA in Excel

VBA

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

MS Access Course (YouTube)

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.