Course Detail
Units:
1.5
Course Components:
Lecture
Enrollment Information
Enrollment Requirement:
Prerequisite: Masters Status in the School Business OR Instructor Consent.
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 its 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 with just a click of a button.