The document named Excel Design & Audit Tips is available for download from this page. The file is about 106K in size and is in Adobe Acrobat v.4 format. To download, view, and/or print the file you'll need a copy of the free Adobe Acrobat Reader. If you don't already have a copy of the Reader, you can get one at Adobe's download site.
Excel Design & Audit Tips
Spreadsheet models are a natural tool for managers but they can be hard to understand and use if they're not well constructed. This guide provides tips on how to create a well-designed worksheet and also describes some auditing techniques. Specific references are to Excel 97. If you're new to using a spreadsheet, also see the handout that's a companion to this one: Spreadsheets: Getting Started.
III. Creating Formulas