Spreadsheets are great. They make complex tasks simple and they allow you to do sums you couldn’t imagine doing without a Maths PHD but they can make your head spin.
Last couple of weeks I’ve been working on business projections for Slidecraft and have been building a model we can use to test some of our assumptions. Over this time I’ve come up with a few strategies to get me through the days when I start suffering with cell-blindness.
Coffee Breaks. Lots of them.
Make sure you have a killer playlist – keep it upbeat or you’ll be asleep.
Excel crashes. Save your work regularly – there’s nothing worse than having to start again. Nothing worse!
Build a template for regular reports.
Wear glasses. Even if you don’t need them.
Use a formula you’ve never used before.
Select a random formula and use it in your spreadsheet.
Snacks – food breaks keep the energy levels high.
Move locations. Every now and then just sit somewhere else.
Work while standing up – if you don’t get more done at least you’ve stretched your legs.
Celebrate when complete.
Any more ideas add them in comments!