Harry Potter fan? Think of Excel as your data’s house elf. An Exc-elf, as I say.
Tonight I am reading Guerilla Data Analysis Using Microsoft Excel. Excellent book: you can tell the authors have been in the foxhole of real-life data analysis and know how to survive!
This comic aside on having hobbies vs. using Excel manually is so on point. When it comes to preparing data, laziness is a virtue. You’ve only got so much mental capacity — using it recklessly on hard-coding cells and re-writing formulas is draining. Learn a few techniques and you’ll be far more productive and insightful when it comes to real data analysis.