OIM2645 Modeling with Excel
2 Advanced Liberal Arts Credits
Fluency in Excel is expected for both internships and nearly every job function for Babson graduates. This course aims to turn novice Excel users into intermediate/advanced users. Students will learn the core principles of robust model construction, data analysis and visualization and Pivot Tables. The primary emphasis is on building models that are highly readable to facilitate collaboration. Along the way students are exposed to a wide ranging set of built-in functions including financial, logical, reference and statistical functions. In addition to functions students are exposed to a number of Excel tools such as Goal Seek, Data Tables for sensitivity analysis and Table, Pivot Table and Conditional formatting for data analysis. You will master "clean modeling" techniques, such as using standardized cell coloring to clearly distinguish inputs from outputs, ensuring your work is professional and easily understood by collaborators.
The curriculum follows a rigorous, hands-on schedule that moves from basic modeling and logical functions to complex financial modeling. You will develop sophisticated realistic tools while being exposed to dozens of Excel's functions including SUMPRODUCT, XLOOKUP, INDEX, UNIQUE, PMT, FV, PV, NPV, SUMIFS and TEXT variations.
Prerequisites: None