CAT 242: Intermediate Microsoft Excel

This course will cover advanced Microsoft Excel concepts and practices that will be beneficial in math, science and business settings. This class may include students from multiple sections. 


2.0 or higher in CAT 140 or instructor permission.

  1. Students will work with Excel Tables, PivotTables, and Pivot Charts.
  2. Students will learn to manage multiple worksheets and workbooks.
  3. Students will develop an Excel Application including working with Macros, Recording a Macro, Running a Macro and protecting against Macro Viruses.
  4. Students will work with advanced functions.
  5. Students will explore financial tools and functions.
  6. Students will perform What-If Analyses.
  7. Students will connect to External data.
  8. Students will collaborate on a Shared Workbook.