Chapter 4 - Projects 4A and 4B

Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Project 4A

Outcomes

Calculate loan options and create a loan amortization schedule.

Objectives

• Use Financial Functions
• Use Goal Seek
• Create a Data Table
• Use Defined Names in a Formula

Project 4B

Outcomes

Automate workbooks to look up information automatically and to validate data. Audit workbook formulas to locate and correct errors.

Objectives

• Use Lookup Functions
• Validate Data
• Audit Worksheet Formulas
• Use the Watch Window to Monitor Cell Values

Using VLOOKUP and IFERROR

I thought this might be helpful as you will be using VLOOKUP in Project 4B.

This is a short tutorial video on using the VLOOKUP and IFERROR functions.

Assignments

• Complete Project 4A on pages 246 thru 264
  • Submit the Project 4A Loan and Costs workbook 
• Complete Project 4B on pages 266 thru 290
  • Submit the Project 4B Lookup Revenue Report workbook

How do I submit my assignment files?