2020-2021 Academic Catalog 
    
    Apr 23, 2024  
2020-2021 Academic Catalog [ARCHIVED CATALOG]

OIT 163 - Microsoft Excel Expert

3 CR
This course introduces students to the advanced features of Microsoft Excel. Students will manage and share workbooks, apply custom formats and layouts, create advanced formulas, and create advanced charts and tables. It is suggested that students possess basic technology skills to be successful in this course. Upon successful completion of this course students will be prepared to complete the Microsoft Excel Expert Certification Exams. [16-32-48] Lab Fee

Requisites: Take OIT 161  with at least a grade of C.
Course Learning Outcomes:
  1. Query large amounts of data.
  2. Apply Solver and Scenario Tools.
  3. Record a macro to automate complex and repetitive tasks.
  4. Import and manage external data and use database functions.
  5. Inspect and prepare a workbook for distribution.