Chapter 23: Developing User-Oriented Applications
In This Chapter
• Describing a user-oriented application
• Looking at the Loan Amortization Wizard, which generates a worksheet with an amortization schedule for a fixed-rate loan
• Demonstrating application development concepts and techniques used by the Loan Amortization Wizard
• Reviewing an application development checklist
What Is a User-Oriented Application?
I use the term user-oriented application for an Excel application that someone with minimal training can use. These applications produce useful results even for users who know virtually nothing about Excel.
The Loan Amortization Wizard discussed in this chapter qualifies as a user-oriented application because anyone can use it without knowing the intimate details of Excel. Replying to a few simple prompts produces a useful and flexible worksheet complete with formulas.
The Loan Amortization Wizard
The Loan Amortization Wizard generates a worksheet that contains an amortization schedule for a fixed-rate loan. An amortization schedule projects month-by-month details for a loan. The details include the monthly payment amount, the amount of the payment that goes toward interest, the amount that goes toward reducing the principal, and the new loan balance.
An alternative to creating an amortization schedule using a wizard is to create a template file. As you'll see, this wizard approach offers several advantages.
Figure 23-1 shows an amortization schedule generated by the ...
Get Excel 2013 Power Programming with VBA now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
