Excel/VBA for Creative Problem Solving

This Specialization is for learners wishing to dramatically change the way that they use Excel spreadsheets by unleashing the power to automate and optimize spreadsheets using Visual Basic for Applications (VBA). The first two courses will teach learners the basics of VBA through the use of dozens of educational screencasts and a series of quizzes and in-application programming assignments. Finally, in Part 3 of the course, learners will complete 3 "real world" and somewhat open ended projects, which are graded through peer review

• Finally, in Part 3 of the course, learners will complete 3 "real world"
• Somewhat open ended projects, which are graded through peer review
• Utilize VBA to define and implement custom user-defined functions
• Create macros to automate procedures in Excel
• Identify the basic programming structures in VBA
• Automate Excel’s Goal Seek and Solver tools and use numerical techniques to create “live solutions” to solve targeting and optimization problems
• 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

• No deep prior experience is required, but basic computer and internet skills are helpful
• Ability to read course instructions in English and complete short practice activities