IST250 — Decision Support MS Excel
Techniques for building complete Excel-based decision support systems in a highly accessible manner. Topics include referencing and names, functions and formulas, charts, pivot tables, macros, programming structures, building user interfaces, and VBA for optimization and simulation. The extended functionality topics include statistical analysis, the Solver and modeling, simulation, and working with large datasets. 3 lecture / 2 laboratory hours
Prerequisites: IST102, IST109, IST123