 |
 |
 |
 |
 |
OBJECTIVES: After completing this class, students will be able to
- Rewrite a math equation in Excel format
- Understand the difference between Accounting and Currency styles
- Use Precedence correctly (PEMDAS) (page 443)
- Insert formulas into an Excel worksheet
- Search for a function
- Use the IF function to make decisions
- Understand absolute versus relative cell referencing (pages 498 - 505)
Challenge yourself:
- Use the PMT function to calculate the payment on a loan
- Use a template to calculate payment on a loan
- Use date functions like NOW and TODAY
The information for this lecture is found in Chapters 14 & 15 of the CMPTR book