1 / 20

Excel Tutorial 3: Working with Formulas and Functions

Excel Tutorial 3: Working with Formulas and Functions. What You Will Do In Tutorial 3. Copy formulas Build formulas containing relative, absolute, and mixed references Review function syntax Insert a function with the Insert Function dialog box Search for a function

miles
Télécharger la présentation

Excel Tutorial 3: Working with 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 Tutorial 3:Working with Formulasand Functions

  2. What You Will Do In Tutorial 3 • Copy formulas • Build formulas containing relative, absolute, and mixed references • Review function syntax • Insert a function with the Insert Function dialog box • Search for a function • Type a function directly in a cell

  3. What You Will Do In Tutorial 3 • Use AutoFill to fill in a formula and complete a series • Enter the IF logical function • Insert the date with the TODAY function • Use the PMT financial function to calculate monthly mortgage payments

  4. Visual Overview

  5. Cell References and Excel Functions

  6. Understanding Cell References • To record and analyze data • Enter data in cells in a worksheet • Reference the cells with data in formulas that perform calculations on that data • Types of cell references • Relative • Absolute • Mixed

  7. Formulas Using a Relative Reference

  8. Formulas Using an Absolute Reference

  9. Using a Mixed Reference

  10. Using the Function Library to Insert a Function • When you select a function, the Function Arguments dialog box opens, listing all arguments associated with that function

  11. Using the Insert Function Dialog Box • Organizes all functions by category • Includes a search feature for locating functions that perform particular calculations

  12. Typing Functions Directly in Cells • Often faster than using Insert Function dialog box • As you begin to type a function name within a formula, a list of functions that begin with the letters you typed appears

  13. Autofill and More Functions 13

  14. Entering Data and Formulas with AutoFill

  15. Returns one value if a statement is true and returns a different value if that statement is false IF (logical_test, [value_if_true,] [value_if_false]) Using the IF Function

  16. Working with Date Functions • For scheduling or determining on what days of the week certain dates occur

  17. Financial Functions for Loans and Interest Payments

  18. Using Functions to Manage Personal Finances

  19. Using the PMT Function

  20. Using the PMT Function

More Related