IT 002 - Advanced ExcelSemester 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.
View Course Offering(s):
Summer Session I 2026
Summer Session II 2026
Summer Session III 2026
Fall 2026
Add to Personal Catalog (opens a new window)
|