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 am a man with an itch. I am endlessly in pursuit of something but not quite sure what. I am sure that it is just around the corner though.

Luck has shone its light my way and I live on the small but beautiful Isle of Man with my wife Donna, our three beautiful kids.

Co-founder of 572 Digital, Slidecraft, FlipRSS and I hope more to follow.

Add Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recent Posts

James Qualtrough

I am a man with an itch. I am endlessly in pursuit of something but not quite sure what. I am sure that it is just around the corner though.

Luck has shone its light my way and I live on the small but beautiful Isle of Man with my wife Donna, our three beautiful kids.

Co-founder of 572 Digital, Slidecraft, FlipRSS and I hope more to follow.

Get in touch