VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in the Microsoft® 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This Specialization will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users.

This Specialization is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.

应用的学习项目

In each module, you will apply the VBA and Excel skills you learn by automating through code various data-related tasks such as collecting, processing, analyzing, and visualizing data. You'll also improve your code, debug it, and address any errors. You will save your work in portfolio of macro-enabled Excel workbooks that you can take with you once you've completed each course.