Ch2_ExcelFormulas_sp10

Ch2_ExcelFormulas_sp10 - Click to edit Master subtitle...

Info iconThis preview shows pages 1–7. 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 (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.)  Good Documentation: Flexible Workbook Design  Formulas (the main topic of Chapter 2) 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 : Dont 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 cells address in the formula.  The cells address is represented by its column and row intersection.  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  Office Button Excel Optionsk Formulas tab...
View Full Document

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 Right Arrow Icon
Ask a homework question - tutors are online