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