Excel/VBA for Creative Problem Solving, Part 2

"Excel/VBA for Creative Problem Solving, Part 2" builds off of knowledge and skills obtained in "Excel/VBA for Creative Problem Solving, Part 1" and is aimed at learners who are seeking to augment, expand, optimize, and increase the efficiency of their Excel spreadsheet skills by tapping into the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA). In Part 2 of the course, learners will: 1) learn how to work with arrays and import/

• Use VBA to import/export arrays from/to Excel
• Describe how text strings in Excel and how to write data to .txt files and import information from .txt files
• Automate the import, modification, and consolidation of information from multiple worksheets into a central worksheet
• Create professional user forms to interface with the user, perform advanced calculations, and manipulate data on the spreadsheet.