Advanced Spreadsheeting

Catalog description

This course focuses on using advanced features of Microsoft Excel to create efficient spreadsheet models and analyze real-world business problems. Because a spreadsheet can be a part of a bigger Information System, Excel can be used as a tool for pre-processing data or integrate with other tools such as databases. Moreover, Visual Basic for Applications built into Excel allows us to develop programs to perform tasks that are not available from the standard Excel interface (buttons and command). Course topics include: an introduction to MIS problem solving approach (e.g, efficient and flexible spreadsheet design), determining effective data display with charts and linking and consolidating worksheets, text functions and formulas, data screening and validation, locating and managing data with reference functions, troubleshooting and customizing workbooks with macro, visual basic programming and other advanced tools, and data analysis. Although certain level of familiarity with programming is preferred, such skills are not required. Prerequisite: MGMT 500.