Course Detail
Units:
3.0
Course Components:
Lecture
Enrollment Information
Enrollment Requirement:
Prerequisites: Full Major or Minor status in the School of Business OR Full Major status in QAMO.
Description
Excel is a powerful computational tool that can be used in many applications. Still, there are many things that you may have wanted to do with a spreadsheet but there was no built-in function or menu item to accomplish your goal. Similarly, you may have desired to automate routine tasks or create a user interface that simplifies tasks for others. Fortunately, Excel can be customized to do much more that what is built-in through it programming language, Visual Basic for Applications (VBA). This class will provide an introduction to creating macros in Excel using VBA. Applications will range from simple tasks like automating formatting, to more complex tasks like creating an interface that will allow users to optimize.