Took a 2-hour LinkedIn Learning class on Excel data validation over lunch last week and cut my typo fixes by about 30% the next day; the little input message prompt helped a ton. Got any other short, practical picks that improved your accuracy or speed — anyone else?
Did a 90-minute LinkedIn Learning on Power Query basics and cut cleanup even more than your 2-hour validation class — setting column types upfront catches typos before they land; after Data > Get Data, set each column’s “Data Type” (Text/Date/etc.) and Excel flags anything off immediately. Caveat: Flash Fill is faster for one-offs, but Power Query wins when the same file repeats.
Turning your input sheet into an Excel Table (Ctrl+T) makes the validation prompts and formats stick to every new row — like guardrails that move with you. Tiny caveat: Tables will auto-fill formulas, so confirm the first pattern before you paste big chunks. @labcompass74 have you paired that with your setup?