Excel: Formulas and Functions

# Excel: Formulas and Functions

## Excel: Formulas and Functions

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
##### Presentation Transcript

1. Excel: Formulas and Functions

2. Objectives • Name a cell or range • Locate and use Excel’s predefined functions • Debug formulas that contain errors • Record and run a macro

3. Referencing Cells • Absolute, relative & mixed • Cell Ranges • A2:A10 (row) • A2:D10 (column) • A2:B6 (range) • Naming a Range of Cells (you can then use a name in formulas)

4. Creating and Using Formulas • Create (=) • Formula Syntax (set of rules) • Operator Precedence (use paragraph symbols)

5. Functions Predefined functions Function Arguments Trig Functions Excel’s trig function express angles in radians Use DEGREES function to convert radians to degrees Matrix Operations (skip)

6. Debugging Excel Worksheets • See Table for Excel Error Messages • Highlight Formulas • Tracing Dependents • Tracing Precedents • Unusual changes in row/column patterns

7. Macros • Stored Collection of Commands • Macro stored as a Visual Basic Module • Subject to viruses • Can only save as .xlsm • Excel files w/o macros saved as .xlsx • Macro created by “recording the steps”