CMIS 257 - Microsoft Excel II

1 Credit (0 lecture, 1 open-lab) 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.