Excel VBA Macros: Custom Functions and Structures

Coursera MOOC / Non-credit USD 49
Enroll now →
Excel VBA Macros: Custom Functions and Structures

About this course

In this course, you'll continue developing your VBA skills in Excel by creating custom functions, making decisions in code, working with variables, and performing repetitive tasks. You'll also debug VBA errors, deal with errors, and improve macro performance. Then, you'll prompt the user for more information and configure macros to run automatically. This is the second course in a multi-course Specialization. All of the courses in this Specialization require that you have a recent version of Microsoft Excel installed. The course setup instructions provided in the first course go into more detail about the hardware and software requirements.

What you'll learn

  • create custom functions in VBA
  • debug VBA errors
  • handle repetitive tasks with macros
  • optimize macro performance
  • prompt users for input in macros

Course objectives

  • improve coding decision-making in VBA
  • develop skills for error handling in VBA
  • automate macro operations

Skills you'll gain

Related courses

Course details are provided by the platform and may change — always confirm on the provider's site. Links may be affiliate links.