College of Dupage

Two computers with an arrow moving between them.

CIS 1222: Advanced Spreadsheets

A collage with a telescope, earth, and a spiral.

Why Enroll in CIS 1222 Advanced Spreadsheets?

The purpose of this course is to continue problem solving skills and programming concepts in Microsoft Excel using the Windows operating system. Topics will include steps in problem solving (Data table, Scenarios, Goal Seek etc.), numerical concepts including variables, data types, operators, expressions, advanced functions (VLookUp, HLookUp, LookUp), PivotTable and PivotChart, advanced chart design and equations in spreadsheet design. This class is designed to integrate all features used in business applications based on the foundations learned in CIS 1221.