Desktop and Modeling Solutions

Catalog description

This course presents an advanced approach to data-intensive problem-solving using Microsoft Excel. Advanced concepts such as external queries, data tables, arrays, iterative techniques and macros will be reviewed. These will then be incorporated into an integrated business model. Emphasis will be on clear, separated input and output, data integrity, user interface design, documentation, maintainability, robustness and user support. (MPA-DA, MPA-DATSCI, MPA-TPA)