About Excel/VBA for Creative Problem Solving, Part 2 course
The Excel/VBA for Creative Problem Solving Part 2 course builds on the knowledge and skills acquired in the Excel/VBA for Creative Problem Solving Part 1 course and is designed for those who seek to complement, extend, 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). In Part 2 of the course, students will: 1) learn how to work with arrays and import/export arrays from/to Excel using VBA code; 2) learn how to work with text strings, write data to .txt files, and import information from .txt files; 3) automate the import, modification, and merging of information from multiple worksheets into a central worksheet, as well as the import of information from multiple workbooks into a central workbook; and 4) gain experience creating professional-quality custom forms to interact with the user, perform complex calculations, and manipulate data in a spreadsheet.
Students with a basic understanding of VBA code and programming structures can skip Part 1 and use the Part 1 demos as a reference. Each module will introduce basic and common problems inspired by situations you might encounter in the real world. To pass each module, you will need to pass a comprehension test and a problem-solving assignment. This course is unique in that the weekly assignments are done in Application Mode (i.e., on your own computer in Excel), giving you valuable hands-on training.
