Share your favourite Excel “cheats” so I can do less work?

Hello! Title says it all. Sick and tired of doing cr@p on Excel. I have some tricks to make some things easier.

Share your favourite excel formulas so I can see if I can embed any of them for my use and we can be a happy anti-work community. <3