Skip to content

Tuesday, November 24th, 2009

Cut Waste! Stop Spreadsheet Sloppiness

July 15, 2008 by Bob Turek  
Filed under Business

541351 spreadsheet 3I read with some pain, but also a chuckle or two, CFO on-line’s sloppy spreadsheet practices article. I like to be organized, send files with naming conventions (source, date, and revision numbers), and like to assist the user of my excel files by using borders, bolded titles, and generally making them readable and printable. Amazingly, according to the article, most students and employees seem to simply send very poor looking documents that at first are unprintable. It’s simply work-creating laziness!

This creates an amazing amount of waste especially if you send your files to two or more people who have to fix your mess.

So here are four things everybody should do to help the world handle your spreadsheets:

1. Title your columns

2. Bold and italicize where necessary to make them easier to read

3. Wrap text (in comment fields in particular)

4. Make them printable

Apparently you will be one of the few who do these simple things and will probably be loved for it. Who knows, it could lead to a promotion.

Do you have any pet peaves related to spreadsheets? Share them! Are you a lazy spreadsheet user? REPENT!

Like this post? See “Related Stories” and “tags” in the detail post. Don’t miss a post! Subscribe via EMAIL.

Image Source: stockxchng.com

  • StumbleUpon
  • Digg
  • Facebook
  • Mixx
  • Google
  • TwitThis
  • Reddit
  • Yahoo! Buzz
  • Slashdot
  • E-mail this story to a friend!
  • BallHype
  • YardBarker

Comments

3 Responses to “Cut Waste! Stop Spreadsheet Sloppiness”
  1. Dorothy says:

    Good tips. I find most people in my organization go WAY too far with colors, fonts, and other fancy and un-helpful formatting tricks. They spend a HUGE amount of time on this foolishness and not enough time on sensible layout, printability, accuracy and the basics.

    I don’t print unless absolutely necessary, but most people DO print, so I feel it’s courteous to at least hit print prieview on the spreadsheets I plan to share. Better than I take a minute or two to make it printable, than that 30 people each do so.

  2. Bob Turek says:

    Absolutely! Thanks for your comments Dorothy.

Trackbacks

Check out what others are saying about this post...
  1. [...] Cut Waste! Stop Spreadsheet Sloppiness @ Project Management 411. [...]



Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!


About Us | Advertise with us | Blog for EveryJoe | Privacy Policy | Terms of Use
Get This Theme | Sitemap


All content is Copyright © 2005-2009 b5media. All rights reserved.