Tutorial 7 - Session 7.2 - PowerPoint PPT Presentation

tutorial 7 session 7 2 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Tutorial 7 - Session 7.2 PowerPoint Presentation
Download Presentation
Tutorial 7 - Session 7.2

play fullscreen
1 / 10
Tutorial 7 - Session 7.2
149 Views
Download Presentation
hope
Download Presentation

Tutorial 7 - Session 7.2

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

  1. Tutorial 7 - Session 7.2 Developing an Excel Application Intro to Excel - Session 7.2

  2. Session 7.2 Objectives • Use the Excel AutoFill feature • Discuss Excel financial functions • Use the Excel FV function • Protect worksheet cells Intro to Excel - Session 7.2

  3. What is a Series? • Related information in adjacent cells • Examples: • Sunday, Monday, Tuesday, Wednesday, … • January, February, March, April, May, … • 10, 20, 30, ... Intro to Excel - Session 7.2

  4. Creating a Series Using AutoFill • Enter one or two initial values • Select the range of cells containing the initial values • Select and drag the fill handle through the rest of the cells Intro to Excel - Session 7.2

  5. Excel Financial Functions • FV - Future value • PV - Present value • PMT - Computes periodic payments • RATE - Computes rate of return • DDB - Computes an asset’s depreciation • IRR - Computes an internal rate of return Intro to Excel - Session 7.2

  6. Using the FV Function • Format: FV(rate, nper, pmt) where • rate is the interest rate per period • nper is the number of periods • pmt is the payments made each period Intro to Excel - Session 7.2

  7. Protecting Cells in a Worksheet • In a protected worksheet: • Data in protected cells cannot be changed • Rows cannot be inserted or deleted • Cell formats cannot be modified • Column widths cannot be changed • Only values in unprotected cells can be changed Intro to Excel - Session 7.2

  8. Unlocking Individual Cells • By default, every cell has the locked property turned on but the worksheet is not protected • Implementing cell protection takes two steps: 1. Turn off the locks in the cells you want unprotected 2. Activate the protection command Intro to Excel - Session 7.2

  9. Unlocking Cells • Select the cells you want unprotected • Select Format Cells,and push theProtection tab • Uncheck the Lockedcheck box Intro to Excel - Session 7.2

  10. Protecting the Worksheet • Enforces the lock/unlock property of each cell • Select Tools Protection Protect Sheet Intro to Excel - Session 7.2