CMIS 286 - Microsoft Excel III

2 Credit: (0 lecture, 2 open-lab, 0 clinical) 2 Contact Hours: [Pre- or co-requisite: CMIS 257 ]

This course provides advanced instruction in Microsoft Excel. Students will create templates, validate entries, and use Excel database capabilities, as well as utilize various analysis and collaboration tools.
OFFERED: every semester

Course Goals/ Objectives/ Competencies:
Goal 1: Manage PivotTable and PivotChart reports.

Create and modify PivotTable reports.
Create and modify PivotChart reports.

Goal 2: Use the Data Analysis, Solver and Scenario Features.

Create scenarios using Solver.
Determine a break-even point.
Create scenarios using the scenario manager.
Create logical functions.

Goal 3: Customize macros and visual basic for applications.

Record a macro and assign it to a button.
Modify a macro.
Code a VBA procedure.

Goal 4: Manage external data.

Import data from a variety of sources.
Export data to a variety of sources.

Goal 5: Collaborate with others.

Create a shared workbook.
Prepare a workbook for distribution.