Ch2_ExcelFormulas_sp10

# Ch2_ExcelFormulas_sp10 - Click to edit Master subtitle...

This preview shows pages 1–7. Sign up to view the full content.

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

View Full Document

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

View Full Document

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

View Full Document
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 &#2; Workbook design goals &#2; Using cell references in formulas Relative Absolute &#2; Using named cell ranges &#2; Troubleshooting formula errors Error Values Formula Auditing Tools &#2; Protecting worksheets Workbook Design Goals &#2; Flexibility: Most important! Outputs should recalculate automatically when inputs change. Inputs should be easy to locate for users to change. &#2; Accuracy: Developer testing ensures logically correct formulas. &#2; Ease of Information Gathering: Use formatting (font color or effects, background cell color, white space, etc.) to make information easy to scan visually. Provide adequate labels for data (column headers, row headers, individual cell labels, etc.) &#2; Good Documentation: Flexible Workbook Design &#2; Formulas (the main topic of Chapter 2) are the foundation of flexible workbook design. Formulas convert workbook inputs to outputs. &#2; Formulas should reference input cells whose contents (values) are apt to change. &#2; Flexible formula design is the most important concept to master for Excel users! &#2; Formula Rule/Guideline : Don’t type anything into a cell if its value can be derived from data in Cell Reference Notations &#2; The contents of a cell can be used in a calculation (formula) by including the cell’s address in the formula. &#2; The cell’s address is represented by its column and row intersection. &#2; Two types of notation exist in Excel. “A1 style” (default notation in Excel) Columns are letters, rows are numbers Column letter is followed by row number “R1C1 style” Change Cell Reference &#2; Office Button Excel Optionsk Formulas tab...
View Full Document

{[ snackBarMessage ]}

### Page1 / 23

Ch2_ExcelFormulas_sp10 - Click to edit Master subtitle...

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

View Full Document
Ask a homework question - tutors are online