html5-img
1 / 7

Excel: Formulas and Functions

Excel: Formulas and Functions. Objectives. Name a cell or range Locate and use Excel’s predefined functions Debug formulas that contain errors Record and run a macro. Referencing Cells. Absolute, relative & mixed Cell Ranges A2:A10 (row) A2:D10 (column) A2:B6 (range)

romriell
Télécharger la présentation

Excel: Formulas and Functions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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”

More Related