About Excel/VBA for Creative Problem Solving, Part 1 course
The Excel/VBA for Creative Problem Solving, Part 1 course is designed for students who want to supplement, expand, optimize, and improve the effectiveness of their Excel spreadsheet skills by leveraging the powerful programming, automation, and customization capabilities available through Visual Basic for Applications (VBA).
This course is the first in a three-part series and specialization that focuses on applying computational methods in Excel/VBA to problem solving. In this course (Part 1), you will: 1) create macros to automate procedures in Excel; 2) define your own user-defined functions; 3) create basic subroutines to interact with the user; 4) learn the basic programming structures in VBA; and 5) automate Excel's Goal Seek and Solver tools and use numerical methods to create "live solutions" to goal setting and optimization problems. Are you new to computer programming? The highly intuitive and visual nature of VBA is perfect for teaching and learning - what a fun way to learn to program! No prior programming knowledge or advanced math skills are required, but experienced programmers will gain new and creative strategies for solving spreadsheet problems. Once you have mastered the basics of VBA, each module introduces fundamental and common problems inspired by situations you might encounter in the real world. To pass each module, you will be required to take a comprehension test and complete a problem-solving assignment. This course is unique in that the weekly assignments are completed on the job (i.e. on your own computer in Excel), giving you valuable hands-on training.
