INFS 3333 Advanced Spreadsheet Modeling
Accessible to almost anyone, the spreadsheet is a simple, yet powerful data analytic tool used by major corporations and small businesses alike. Users may develop spreadsheet models by themselves to determine key measures of success at operational, managerial, and strategic levels. This course introduces advanced Excel formulas, techniques, and procedures for spreadsheet modeling (including but not limited to macros, automation, Visual Basic for Applications (VBA), Pivot table, and PowerPivot to Excel) so as to harness its power in data sensemaking and decision support. The technical skills and managerial capabilities acquired will be useful to careers in the financial, medical, retailing, manufacturing, transportation, and construction fields, to name but a few.
Prerequisite
All students pursuing a Bachelor of Business Administration, Bachelor of Arts in Economics, or Bachelor of Science in Materials Management and Logistics from VCoBE, must apply for and be admitted to VCoBE before they are allowed to enroll in the Advanced Business Core and Major coursework for their degree.