CGS 2103

Spreadsheet Applications (3)

Prerequisite: CGS 1100

Classification: Dual

Spreadsheets are powerful software tools that allow users to manipulate data. In this course, students use a modern spreadsheet package to create formulas and functions to solve problems as well as format the data for attractive presentation. Students learn to combine multiple worksheets and multiple workbooks with 3-D references, as well as present data as a pivot table. Students learn to use a variety of powerful financial functions, and learn to do "what-if" analysis on data using one- and two-variable data tables. Finally students learn to import a variety of data into a spreadsheet including text, database tables, XML data and other tabular data. This course is designed to prepare students for the current Microsoft Office Excel exam.