CAP 205 - Advanced Excel

3 credits (PREREQUISITES: CAP 110 and SUCCESSFUL COMPLETION OF FOUNDATIONAL MATH, or DEPARTMENTAL PERMISSION)

This course is designed to develop students' expertise managing Excel spreadsheets, leading to preparation to take the related Microsoft certification examination upon completion. Students will apply advanced formulas and functions, create PivotTables to manage large worksheets, and practice applications designed to analyze data to solve business or scientific problems. Students will enhance and integrate worksheets using Microsoft Office features. Learning outcomes include competency in drafting professional budgets, team performance charts, sales invoices, and exercise logs. CL (F, Sp, Su)