Oct 28, 2020  
2018-2019 Undergraduate Catalog 
2018-2019 Undergraduate Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

IT 359 - Advanced Spreadsheet Applications

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: 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.

Add to Portfolio (opens a new window)