BID-212 — Effective Spreadsheet Design
What makes a good spreadsheet? Two things: good design and good data. This may seem obvious, but quite often individuals simply start to create a spreadsheet with no design plans at all. That results in the same product as a new house built with no floor plan and/or blueprint to guide the construction. Good design doesn't mean making your spreadsheet simply look good - although appearance can definitely help. Good spreadsheet design consists of organizing your data logically and ensuring that all your formulas are correct. While computers take the vast amount of the tedious work out of creating and maintaining spreadsheets. The old GIGO adage (garbage in, garbage out) still applies, and you'll need to focus on that when you start creating your own spreadsheets.