WesMaps - Wesleyan University Catalog 2017-2018       Summer Session       Winter Session       Home       Archive       Search
CS92PROD
Business Modeling with Excel
QAC 171
Spring 2018 not offered

Broadly speaking, this course is about evidence-based decision-making. It is intended for students with a background in Excel and VBA who want to learn how to use spreadsheets to develop business and financial models and communicate the results. Model building is different from the usual Excel skills as it focuses more on the analytical/mathematical aspects than on data wrangling and requires some basic familiarity with economic/financial models and data analysis tools. We will start with problems where the inputs are deterministic and we must decide on optimal allocation of resources. We will then advance to problems with stochastic inputs and explore solutions either through simulation or through optimization of goal functions. Through this work we will develop the appropriate programming skills (e.g., VBA) and learn to effectively use Excel to implement our models and display the results of our analyses.
Credit: .25 Gen Ed Area Dept: NSM QAC, SBS QAC
Course Format: LaboratoryGrading Mode: Student Option
Level: UGRD Prerequisites: QAC151 AND ECON300
Fulfills a Major Requirement for: None

Last Updated on MAR-29-2024
Contact wesmaps@wesleyan.edu to submit comments or suggestions. Please include a url, course title, faculty name or other page reference in your email ? Wesleyan University, Middletown, Connecticut, 06459