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.
Add to Personal Catalog (opens a new window)
|