Learning Outcomes

Upon successful completion of the course, the student will be able to:

• Use correct terminology when discussing spreadsheet applications.
• Work with multiple worksheets and cell protection.
• Create complex charts and forecasts using trend lines.
• Use logical functions such as: IF, AND etc.
• Use functions related to IF such as COUNTIF and VLOOKUP.
• Use financial functions such as PMT, FV, NPER, IRR, NPV and RATE.
• Perform data management of lists using data forms, auto filter, sort, subtotal and pivot tables.
• Use goal seek and create scenarios.
• Develop a multi-sheet worksheet model capable of sensitivity analyses.

Effective as of Fall 2003