CMIS 257 - Microsoft Excel II

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

This course provides experience using intermediate features of Microsoft Excel. Students will create and edit worksheets, charts, functions, and formulas.
OFFERED: every semester

Course Goals/ Objectives/ Competencies:
Goal 1: Enhance Microsoft Excel workbooks by using functions.

Construct advanced functions.
Define a named range.

Goal 2: Construct Microsoft Excel workbooks with charts and diagrams.

Create and modify a chart.
Create and modify SmartArt graphics.

Goal 3: Manage large workbooks.

Modify page breaks.
Set print areas.
Filter data based on criteria.