Spreadsheet survival guide.

S

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!

About the author

James Qualtrough

I live on the small but beautiful Isle of Man with my wife, Donna and our twin girls Ella & Erin. I'm Head of Digital Media at Home Strategic and Co-Founder of Slidecraft.

Add Comment

Recent Posts

James Qualtrough

I live on the small but beautiful Isle of Man with my wife, Donna and our twin girls Ella & Erin. I'm Head of Digital Media at Home Strategic and Co-Founder of Slidecraft.

Get in touch