CITA 315 - Microsoft Excel for Business Applications

Credit Hours: 3
Lecture Hours: 3
Laboratory Hours: 0

Prerequisite(s): CITA 110 or CNST 260 or CARP 170

Restriction(s): None

Corequisite(s): None

This course is designed to provide students hands-on training using Microsoft Excel to create efficient spreadsheets for business analysis, decision making and presentations. Areas of focus include the use of advanced functions, formulas and formatting; graphs and charts; and analytical tools.

Student Learning Outcomes of the Course:

Demonstrate ability to apply professional formatting to spreadsheets.
Preparation of meaningful charts as a method of synthesizing data.
Demonstrate ability to apply conditional formatting and create tables as a method of synthesizing data.
Demonstrate ability to utilize advanced formulas and functions in order to present the results of data analysis.
Completion of a capstone project.