2020-2021 Catalog

CGS 2103 Spreadsheet Applications

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.

Credits

3

Prerequisite

CGS 1100

Classification

Dual