I process about 1,000 rows a day in Excel and Access and want to get my error rate under 0.5%. Any course recommendations that focus on building validation rules, import templates, and a simple two-pass check workflow (bonus if it covers TextExpander or AutoHotkey) rather than just typing speed?
And processing 1,000/day: take Leila Gharani’s Power Query, then https://exceljet.net/data-validation; script @AutoHotkey snippets for repetitive fields.
I got under 0.5% at about 1,000 rows/day by routing everything into an Access staging table with strict data types/required fields and lookup relationships, importing via a saved spec so bad rows dump to an error table for a quick “two-pass check” before the final append. It takes an hour or two to set up but pays back fast; if you want training, the LinkedIn Learning Access validation lessons are decent — are you open to the staging-table approach?