2022-2023 Academic Catalog 
    
    Jan 30, 2023  
2022-2023 Academic 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. Import, format, and transform data from external sources.
  2. Create and modify PivotTables and PivotCharts to transform and visually present large quantities of data.
  3. Use advanced functions to transform and analyze data.
  4. Demonstrate data management and error control within workbooks.
  5. Create and modify macros to automate complex and repetitive tasks.
  6. Prepare and distribute workbooks for collaboration with others.