Chapter 2 - Click to edit Master subtitle style Excel...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Click to edit Master subtitle style Excel Formulas Chapter 2 Topics from Chapter 2  Workbook design goals  Using cell references in formulas Relative Absolute  Using named cell ranges  Troubleshooting formula errors Error Values Formula Auditing Tools  Protecting worksheets Workbook Design Goals  Flexibility: Most important! Outputs should recalculate automatically when inputs change. Inputs should be easy to locate for users to change.  Accuracy: Developer testing ensures logically correct formulas.  Ease of Information Gathering: Use formatting to make information easy to scan visually.  Good Documentation: Developer’s notes User instructions Flexible Workbook Design  Formulas are the foundation of flexible workbook design.  Formulas convert workbook inputs to outputs.  Formulas should reference input cells whose contents (values) are apt to change.  Flexible formula design is the most important concept to master for Excel users!  Formula Rule/Guideline: Don’t type anything into a cell if its value can be derived from data in Cell Reference Notations  The contents of a cell can be used in a calculation (formula) by including the cell’s address in the formula.  The cell’s address is represented by its column and row intersection.  Two types of notation exist in Excel....
View Full Document

This note was uploaded on 08/15/2011 for the course ACIS 2504 at Virginia Tech.

Page1 / 21

Chapter 2 - Click to edit Master subtitle style Excel...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online