People joke that being Canada is like living in an apartment where the person living in the floor below is a crack addict. Now, that crack addict is trying to steal your toilet to sell it for crack.
In my past life, I worked as Data Manager in a movie, at the lunch break, everyone would smoke pot as if nothing. I couldn't do it because I can't use computers while high.
Sure, but sometimes you need to do a pivot table and get transformed, or you while working you accidentally made it a number, or just because excel being excel it import the number as scientific notation, or any other case.
It completely screws up numbers if the column is a number and the number is over 15 digits long.
I work in insurance in Brazil, by standards of our regulatory body, claims numbers must be a string of 20 numbers (zfill(20) if needed). You can't imagine the amount of times excel had fucked me up rounding down the claim numbers, this is one of the first things I teach to my interns and juniors when they're working with the claims databases.
Oh yes, I remember using power query for a few months once I started working with bigger databases, but I saw that moving to Python would be better carrer wise and never came back to excel to do actual work (but at the end everything get exported to excel)
Ah fuck, this happened me with the Chainladder library. Had to modify the source code to change the M to ME.