Spreadsheet “Worst Practices”

Erin McCune

August 3, 2008

Excel_icon

Attention Excel users! A couple related articles from CFO.com on spreadsheet worst practices and how to fix them. The first article generated so many emails that they published a follow up with even more tips.

Spreadsheet "Worst Practices"
Here's how finance executives abuse the most-useful of computer programs — and how to do better.
Shahid Ansari and Richard Block
CFO.com | US
May 14, 2008

Sloppy Spreadsheets: Readers Speak Out
Readers make some pointed additions to CFO.com's "worst practices" list.
CFO.com Staff
CFO.com | US
June 18, 2008

Spreadsheet Worst Practices

  1. Poor segregation of data (don't embed data in formulas)
  2. Poor documentation of assumptions (leads to misinterpretation, or worse yet, forgetting why you used the numbers you did)
  3. Poor documentation of constraints (interim calculations highlight data
    difficulty, faulty assumptions, and misapplied algorithms)
  4. Difficulties in making changes (build spreadsheets anticipating that
    you'll be asked to modify and recalculate with a variety of different
    assumptions)
  5. "Now It's Here; Now It's Not" (retain original calculations for comparison to what-if scenarios)
  6. The Presentation Readiness Problem (include meaningful column and row labels so that the entire spreadsheet can be easily incorporated into PowerPoint)

The article includes examples of both worst and best practices that you can download. And the follow up article includes rants and raves from readers and even more tips.

And don't forget my previous post on Excel Tips and Tricks (my clients are still amazed by the easy gantt chart)

Recent Payment Views

Payments Post #13: At the Intersection of Tech, Regs, and Business Partnership

Payments Post #13: At the Intersection of Tech, Regs, and Business Partnership

This month, Cici Northup joins regular contributor Justin Pituch to recap positive news in the form of fast payments growth, new fraud mitigation strategies, and evolution in cross-border transfers. All reflect, to varying degrees, the unique dynamic in the payments industry created by the intersection of technology, regulation, and new business partnerships.

read more
Payments Orchestration: What Comes Next?

Payments Orchestration: What Comes Next?

Orchestration providers have certainly come a long way, and can enable powerful capabilities and benefits for the merchants that employ them. This post explores some of the possibilities Glenbrook has been thinking about for where Orchestration (and even orchestration) can go next.

read more
Payments Post #13: At the Intersection of Tech, Regs, and Business Partnership

Payments Post #12: Lessons from Change

In this month’s Payments Post, we want to draw your attention to several recent fraud incidents that underscore the criticality of effective risk management to your business and the safety and soundness of the payments industry.

read more

Glenbrook Payments Boot CampTM workshop

Register for the next Glenbrook Payments Boot Camp®

An intensive and comprehensive overview of the payments industry.

Train your Team

Customized, private Payments Boot CampsTM workshops tailored to meet your team’s unique needs.

OnDemand Modules

Recorded, one-hour videos covering a broad array of payments concepts.

GlenbrookTM Company Press

Comprehensive books that detail the systems and innovations shaping the payments industry.

Launch, improve & grow your payments business