Central Arizona College

CBA 113C MS Excel - Advanced

Credit Hours: 1
Effective Term: Fall 2013
SUN#: NA
AGEC: (None)

Credit Breakdown: 3 Labs
Times for Credit: 1
Grading Option: A/F
Cross-Listed:

Description: Use Data analysis, PivotTables and Macros in MS Excel to solve business problems.

Prerequisites: CBA113B or Instructor consent

Corequisites: None

Recommendations: File management and Operating system knowledge

Measurable Student Learning Outcomes
1. (Synthesis Level) Create and modify PivotTable and PivotChart reports to display relationships and trends. 2. (Application Level) Use the Data Analysis, Solver and Scenario tools to interpret complex business data and provide realistic solution options. 3. (Synthesis Level) Build and modify macros that seamlessly automate complex and repetitive tasks.
Internal/External Standards Accreditation