May 03, 2026  
2026-2027 College Catalog 
    
2026-2027 College Catalog

OFT 220 - Advanced Spreadsheet Design


3 Credit Hour(s)
2 Lecture Hour(s)
2 Lab Hours(s)
Prerequisite(s): OFT 104  
This course is a continuation of CIS 104 and builds upon basic design skills. It provides the student with an opportunity to develop advanced techniques in the design of business applications. Advanced study of special mathematics, logical, and database statistical functions will provide the foundation for advanced program design. Problem solving for managerial and accounting decision making is emphasized, and design techniques incorporating the use of macros, menu layout, and data transfer are included using Microsoft Excel. This course will help the student prepare to take the Microsoft Certified Application Specialist Exam.