main navigation
my pace

CIS 122 Advanced Spreadsheet Skills

Course Description:This course covers in-depth the advanced features of spreadsheet programs. Emphasis is placed on using spreadsheets to solve problems. Topics include: good spreadsheet design, graphing, working with financial tools and analytical functions, automating spreadsheets with macros, exploring what-if alternatives with pivot tables and charts, data tables, Goal Seek, Solver and Scenarios, using database functions, and developing an Excel application.

Course Rotation: Fall;NY:PLV

Credits

2 credits

Prerequisite

CIS 101 Minimum Grade of D or CIT 110 Minimum Grade of D or TS 105 Minimum Grade of D or IS 223 Minimum Grade of D or CS 121 Minimum Grade of D or CIT 312 Minimum Grade of D or CS 122 Minimum Grade of D