Excel2010+ReferenceMaterial

Everything **YOU** need to know about Excel 2010:

Ø Excel 2010 Formulas & Functions ……………………………………………….….. 2 Ø Conditional Formatting ……………………………………………….….. 2 Ø Cell Styles ……………………………………………….….. 4 Ø Formulas & Functions ……………………………………………….….. 4 Ø Basic Formulas ……………………………………………….….. 5 Ø Ranges & Individual Cells ……………………………………………….….. 6 Ø Copy a Formula ……………………………………………….….. 6 Ø Referencing Cells in Formulas ……………………………………………….….. 6 Ø Quick Reference Guide ……………………………………………….….. 8 Ø Practical Purposes of Excel Formulas ……………………………………………….….. 8 Ø Commonly Used Functions & Formulas ……………………………………………….….. 10
 * Table of Contents **
 * Formula Basics ……………………………………………….….. 2
 * Order of Operation ……………………………………………….….. 2
 * Add the Values in Rows or Columns ……………………………………………….….. 5
 * Find the Average, Maximum, or Minimum ……………………………………………….….. 5
 * Using the Fill Handle ……………………………………………….….. 6
 * Using Traditional Copy & Paste ……………………………………………….….. 6
 * Relative References ……………………………………………….….. 7
 * Absolute References ……………………………………………….….. 7
 * Mixed References ……………………………………………….….. 7
 * References to Other Worksheets ……………………………………………….….. 7
 * Other Workbook References ……………………………………………….….. 8
 * Add, Subtract, Multiple & Divide ……………………………………………….….. 8
 * Understanding Error Values ……………………………………………….….. 8
 * Using Date & Time Formulas ……………………………………………….….. 9
 * Math & Trig Icon ……………………………………………….….. 10

Ø Logical Icon ……………………………………………….….. 11

Ø Lookup & Reference Icon ……………………………………………….….. 12

Ø Date & Time Icon ……………………………………………….….. 12

Ø AutoSum Icon ……………………………………………….….. 14

Ø Statistical Icon ……………………………………………….….. 14

Link: [| http://www.usd.edu/academics/center-for-teaching-and-learning/upload/Excel-3-Formulas-and-Functions.pdf]