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.
What you'll learn
understand VBA basics
automate spreadsheet tasks
create VBA macros
develop problem-solving projects with VBA
Course objectives
equip learners with the skills to optimize spreadsheet functionality
provide practical experience through peer-reviewed projects