Excel Module II

NONCR-GP.0933,  points.

Courses

This workshop introduces students to Excel’s advanced tools for data analysis and modeling. Topics include shortcut keys, sorting and filtering, conditional formatting, macros, a variety of formulas (if, lookup, index, match, etc.), array formulas, graphing, pivot tables and charts, what-if analysis (scenario manager, goal seek, and data tables), and regression analysis.



Prerequisites:

CORE-GP.1021 or concurrently

Semester Instructor Syllabus Link
Spring 2011Shanna RoseSyllabus
Spring 2013Shanna RoseSyllabus
Fall 2012Shanna RoseSyllabus
Spring 2012Shanna RoseSyllabus
Fall 2011Shanna RoseSyllabus
Semester Instructor Evaluation Link
Fall 2013Justin WalterEvaluation
Spring 2013Shanna RoseEvaluation
Spring 2012Rose, ShannaEvaluation
Spring 2011Rose, ShannaEvaluation
Fall 2010Bennett, PaulEvaluation
Puck with Street Sign