I taught myself VBA when I inherited a job that involved taking data from multiple sources and producing summary reports of various types for multiple stakeholders. The person before me spent days each week doing it, it took me about a week of learning and playing to bring that down to 5 minutes or so.

I found VBA useful for dealing with administrivia.

I ended up doing similar things multiple times afterwards, with variations on source data (excel, text files, word docs), source data location (local drive, network, databases, SharePoint) and output (pivots, charts, tables, text files, email, word docs, etc.) depending on what was needed. Someone else mentioned data validation already.

Automate the boring stuff.

Having been on a few Segway tours I was surprised when they stopped making them. Easy to learn, fun to ride. Eventually they will age out and be gone. I wouldn’t buy one for myself to have at home, but for whizzing around sightseeing when on holiday they’re great.