Nov 30, 2024  
2021-2022 Undergraduate Bulletin 
    
2021-2022 Undergraduate Bulletin [ARCHIVED BULLETIN]

Add to Personal Catalog (opens a new window)

IT 002 - Advanced Excel

Semester Hours: 2


This course introduces students to advanced Excel features and functionalities. Using the experiential learning approach, students learn to apply their knowledge to solve business problems. Topics include Excel tables, PivotTables and PivotCharts, working with multiple worksheets, simple macros, advanced conditional and lookup functions, financial functions, advanced conditional formatting, what-if analysis, and collaboration on Excel files.

Prerequisite(s)/Course Notes:
IT001

The course content is relevant to the Microsoft Office Specialist’s (MOS) certificate Excel Expert 2016: Interpreting Data for Insights.





Add to Personal Catalog (opens a new window)