Introduction Excel Chapter 4

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

Finances and spreadsheets are a natural match, and, as you will learn, Excel excels at both! 

WARNING! If you are buying a home or already paying a mortgage, the loan amortization table can reveal some pretty depressing data at the beginning of the loan. Lol! But don't worry too much, it gets better as the payments continue on :)

 

Chapter Outcomes:

• Calculate loan options and create a loan amortization schedule.

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

Assignment

Complete the step-by-step Projects 4A and 4B to introduce yourself to the application features, then demonstrate your mastery of the features by completing Project 4G.

Don't forget! You will also need to participate in the weekly discussion.