I had a job at an actuarial firm once and it would frustrate the hell out of me to see people constantly having to spend ages and ages doing ‘join’ operations using Excel formulae, not knowing that that’s what they were doing, spending ages and ages on such tasks, holding Excel training sessions on how to use functions like INDEX and MATCH, using a bunch of custom-made macros just to give names to columns, and making mistakes that wouldn’t even be possible with a SQL query.
They were bleeding time and money at an astronomical rate, but it didn’t matter because their competitors were just as bad.
I had a job at an actuarial firm once and it would frustrate the hell out of me to see people constantly having to spend ages and ages doing ‘join’ operations using Excel formulae, not knowing that that’s what they were doing, spending ages and ages on such tasks, holding Excel training sessions on how to use functions like INDEX and MATCH, using a bunch of custom-made macros just to give names to columns, and making mistakes that wouldn’t even be possible with a SQL query.
They were bleeding time and money at an astronomical rate, but it didn’t matter because their competitors were just as bad.