2020-2021 Catalog 
    
    Aug 06, 2020  
2020-2021 Catalog

CSA 138 - Microsoft Excel


Description: Practical application on the basic functions of Microsoft Office Excel using the Windows Operating System. Emphasis on creating worksheets for data input and analysis.

Credits: 2
Lecture: 2
Course Content:
  1. Worksheets
  2. Formulas and functions
  3. Charts
  4. Worksheet appearance
  5. 3D referencing, structured references and what-if analysis
  6. Tables and named ranges
  7. Auditing, analyzing and consolidating data
  8. Ranges, data tables and pivot tables

Learning Outcomes:
  1. Create worksheets containing data and formulas. (1-2)
  2. Create worksheets with advanced features. (1-8)
  3. Format and analyze data. (2-8)
  4. Format, modify, and organize worksheets. (1-8)