CGS2103 — Spreadsheet Applications
CGS2103 - Spreadsheet Applications CGS2103 - Spreadsheet Applications 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. Terms Classification: Dual
Prerequisites: CGS1100
Part of
- Accounting Technology, A.S.
- Associate in Arts Degree Requirements
- Business Administration, A.S.
- Computer Information Technology, A.S.
- Engineering Technology
- Medical Office Administration, A.S.
- Office Administration
- Business Management, College Credit Certificate
- Geographic Information Systems, College Credit Certificate
- Information Technology Analysis, College Credit Certificate
- Information Technology Support Specialist, College Credit Certificate
- Office Management, College Credit Certificate
- Office Specialist, College Credit Certificate
- Office Support, College Credit Certificate