Apr 25, 2024  
2011-2012 Undergraduate Catalog 
    
2011-2012 Undergraduate Catalog [ARCHIVED CATALOG]

COS 213 - Advanced Excel Spreadsheet Design


This course explores advanced techniques in spreadsheet software as used to develop business applications.  Topics include data operations, advanced statistical and financial functions, advanced charting and pivot tables, goal seeking and what-if analysis, management of large workbooks, and macros.  The programming language VBA (Visual Basic for Applications) is introduced.  This course assumes skills in Excel data entry, formula writing, and charting.  A student with no background in Excel should first complete COS 103 Introduction to Spreadsheets.

Credits: 2