2021-2022 Catalog 
    Feb 22, 2024  
2021-2022 Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

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, create pivot charts and tables, as well as utilize various analysis and collaboration tools.  
OFFERED: every semester

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

  1. Create and modify PivotTable reports. 
  2. Create and modify PivotChart reports. 

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

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

Goal 3:  Customize macros and visual basic for applications. 

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

Goal 4:  Manage external data. 

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

Goal 5:  Collaborate with others. 

  1. Create a shared workbook. 
  2. Prepare a workbook for distribution. 

Add to Portfolio (opens a new window)