1 / 7

Excel: Formulas and Functions

This module covers naming cells, using predefined functions, debugging formulas, and creating macros in Excel. Discover referencing techniques, formula creation, function syntax, and error debugging methods. Learn about trigonometric functions, matrix operations, and macro creation in Excel. Enhance your skills in formulas, functions, and macros to increase productivity and efficiency in Excel tasks. Ideal for those seeking to excel in data management and analysis using Excel.

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