CTA 116 - Personal Computer Spreadsheet Applications

4 credit hours - Four hours of lecture and directed laboratory weekly; one term.
Formerly CSI 124 - Personal Computer Spreadsheet Applications

Use Microsoft Excel to study the basics of spreadsheet setup, data manipulation and program functions. Learn more advanced features including functions, charts, lists (databases), macros, World Wide Web functions, integration with other applications, validation, 3D references, data tables, scenario manager, solver, importing external data and auditing features. Use a wide variety of practical examples to foster an understanding of different ways Excel can be applied to personal and business needs. This course prepares students to take the Microsoft Office Specialist (MOS) - Excel 2016 industry certification exam (extra fee).

Note: Users with no prior software applications experience are encouraged to take one of the following before taking this course: CTA 100 or CTP 103 . Typically offered MC and OL; fall, spring and summer terms.

Course Outcomes:

Describe the use of spreadsheets.
Identify the parts of the Excel spreadsheet window.
Create and save a basic Excel spreadsheet.
Apply Excel formatting features to create a professional looking spreadsheet.
Create formulas and use functions to perform calculations.
Create charts to enhance a workbook.
Create Excel Tables, PivotTables, and PivotCharts
Manage multiple Excel worksheets and workbooks
Use advanced functions and conditional formatting in Excel.
Develop an Excel application.
Work with Excel’s financial tools and functions.
Perform What-If analyses.
Import and use data from other sources to an Excel spreadsheet.