IT 359 - Advanced Spreadsheet Applications

Description:
Advanced spreadsheets for business applications such as design of multiple sheet workbooks and templates, advanced functions and formulas, enhanced formats, lists, and pivot tables.

Prerequisites:
Prerequisites: IT 258 or IT 260.

Credits: (4)

Learner Outcomes:
Upon successful completion of this course, the student will be able to:

Construct simple and compound statements and selected functions.
Examine lists, data filters and subtotals.
Employ macros.
Apply What if analysis, goal seek, forecasts.
Analyze data with Pivot Tables and Pivot Charts.
Demonstrate the application of common statistical methods using spreadsheet formulas.

Anticipated Course Offering Terms and Locations: