Spreadsheets for Business Analysis
Use of spreadsheets to support business analysis and decision making. Includes sensitivity analysis, pivot tables, introductions to databases and macros, charting, and similar topics.
 Hours3.0 Credit, 3.0 Lecture, 0.0 Lab
Course Outcomes: 

Efficient use of higher Excel functions

Demonstrate ability to use higher functions of Excel in analyzing business data

Accurate analysis

Conduct the assigned analyses in Excel within the alloted time with 90% or higher accuracy.

Connecting optimization models and pivot tables to databases

Connect optimization models and pivot tables directly to large databases.