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 I 2025
Summer II 2025
Summer III 2025
Fall 2025
Add to Personal Catalog (opens a new window)
|