2019 - 2020 Catalog 
    
    Oct 28, 2020  
2019 - 2020 Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

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.

  1. Construct advanced functions.
  2. Define a named range.

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

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

Goal 3:  Manage large workbooks.

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



Add to Portfolio (opens a new window)