The Best Excel VBA online courses and tutorials for beginners to learn Excel VBA in 2020.

Microsoft Excel. It is one of the most popular and used applications in the world, especially in business. Most people can use it to manage data and run simple calculations. But did you know Excel has a programming language built into it, and it can do so much more?

The Visual Basic for Applications (VBA) programming language allows you to automate routine tasks in Excel and it is not as hard to learn as most people think.

What are the advantages of VBA?

  • It automates routine and repetitive tasks seamlessly.
  • It reduces the formulas burden used in Excel reports.
  • It protects workbooks and hides worksheets.
  • It reduces the turnaround time.

Disclosure: Coursesity is supported by the learners community. We may earn an affiliate commission when you make a purchase via links on Coursesity.

Top Excel VBA Tutorials, Courses Certifications List

  1. Excel / VBA for Creative Problem Solving

  2. Unlock Excel VBA and Excel Macros

  3. AutoCAD to Excel - VBA Programming - Hands On

  4. Master Macros in Microsoft Excel Plus Excel VBA

  5. Learning VBA in Excel

  6. Visual Basic for Excel - Microsoft VBA Excel Tutorial

  7. Excel VBA: Process Modeling

  8. Master Excel VBA: Learn Programming for the Business Professional

  9. Developing for Excel with VBA

  10. Excel VBA Programming - The Complete Guide

  11. Excel/VBA for Creative Problem Solving, Part 1

  12. Excel/VBA for Creative Problem Solving, Part 2

1. Excel / VBA for Creative Problem Solving

In this course, you will learn to optimize your Excel spreadsheets with the help of VBA. You will also learn how to automate your Excel spreadsheets with Visual Basic for Applications. Speaking clearly, you will learn the basics of Visual Basic for Applications (VBA) for automating and optimizing spreadsheets. Moreover, you will perform 3 "real world" open-ended projects.

Course rating: 4.9 out of 5.0 ( 3,099 Ratings total)

In this course, you will learn how to:

  • gain skills like Microsoft Excel VBA, Computer Programming, Problem Solving, Arrays, and Debugging.
  • understand the basics of Visual Basic for Applications (VBA).
  • automate and optimize your Excel spreadsheets with the help of VBA.

You can take Excel/VBA for Creative Problem Solving Certificate Course on Coursera.

2. Unlock Excel VBA and Excel Macros

In this course, you will understand how to use the right syntax in VBA and enhance your current Excel files & automate your work with it. You will learn how to use the macro recorder for simpler tasks and improve the code. Moreover, you will learn to import data from other files and export data to text files.

Course rating: 4.6 out of 5.0 ( 19,624 Ratings total)

In this course, you will learn how to:

  • enhance your current Excel files & automate your work with VBA.
  • master Excel VBA & Macros.
  • directly apply the Excel VBA example files included in your own work.
  • reduce manual routine tasks to the click of a button.
  • make your work-life easier.
  • create simple solutions to complex problems by levering Excel functionality with Macros.
  • use VBA when you reach a limitation.
  • easily adjust the VBA code you find online to fit your purpose.

The course includes:

  • Understand how to use the right syntax in VBA
  • Useful Excel VBA codes you can directly use for your work
  • Use the macro recorder for simpler tasks and improve the code
  • Working with the Visual Basic Editor
  • Debugging tools and error handling methods
  • Different ways to reference ranges and cells
  • Different methods to loop
  • How to work with data types
  • Pivot Tables in Excel using VBA
  • Importing data from other files and exporting data to text files
  • Interacting with other applications (Word, PowerPoint, Outlook)
  • ActiveX and Userforms to enhance the Excel interface
  • All the knowledge you need to automate tasks in Excel

You can take Unlock Excel VBA and Excel Macros Certificate Course on Udemy.

3. AutoCAD to Excel - VBA Programming - Hands On

In this course, you will learn how to export AutoCAD drawing information to Excel (and other Formats) using Visual Basic for Applications (VBA). Initially, you will learn how to design User Interface and how you can code the logic behind the control and explain every single line in detail. You will also acquire a good understanding of VBA Programming. Moreover, you will learn to build your own program or build upon the projects that you will develop throughout this course.

Course rating: 4.6 out of 5.0 ( 73 Ratings total)

In this course, you will learn how to:

  • extract LWPolyline objects into a CSV (or a Pipe) Delimited file.
  • import Excel Spreadsheet into AutoCAD.
  • import CSV (or Pipe) Delimited file into AutoCAD.
  • design a User Interface (UI) and write the code behind the control.
  • understand some VBA programming techniques (e.g. Debugging, ErrorHandling, Conditionals, Looping, and Selection Set.)

You can take AutoCAD to Excel - VBA Programming - Hands On! Certificate Course on Eduonix.

4. Master Macros in Microsoft Excel Plus Excel VBA

In this course, you will learn how to build a foundation of working with Excel Macros and VBA. This foundation will be built as you engage and participate in project-based Excel Macro/VBA exercises within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.

Course rating: 4.5 out of 5.0 ( 9,108 Ratings total)

In this course, you will learn how to:

  • automate daily routine tasks within Excel
  • ensure best practices when creating macros and streamline your VBA code.
  • determine when it is best to use the Macro recorder versus VBA.
  • write custom VBA Macros to create more robust automation.
  • understand VBA programming concepts to create dynamic, re-usable code.
  • complete real-world Macro/VBA projects from beginning to end.

The course includes:

  • Automate placing and formatting a title on a worksheet
  • Interact with the users of your Macros through Input and Message boxes in order to receive input on how a Macros should work
  • Cleaning up multiple Excel worksheets and prepare the data to be reported on
  • Create a report based on multiple sets of data found within multiple Excel worksheets, copying data from one Worksheet into the Master report worksheet
  • Automate the creation of Excel Formulas to SUM data up in your report
  • Working with Excel VBA User forms
  • Importing data from external text files

You can take Master Macros in Microsoft Excel (Plus Excel VBA) Certificate Course on Udemy.

5. Learning VBA in Excel

In this course, you will learn how to automate routine tasks and customize the functionality of Excel features in Visual Basic for Applications (VBA).

Course rating: 112,221 total enrollments

In this course, you will learn how to:

  • create subroutines and functions to hold code.
  • customize the functionality of Excel features in VBA.

The course includes:

  • Visual Basic for Applications
  • Defining Variables, Constants, and Calculations
  • Adding Logic to Your VBA Code
  • Debugging Your VBA Code
  • Managing Workbook Elements and Data in VBA
  • Adding Advanced Elements to Your Workbook
  • Using Excel Events in Your VBA Code

You can take Learning VBA in Excel Certificate Course on LinkedIn.

6. Visual Basic for Excel - Microsoft VBA Excel Tutorial

In this course, you will how to apply the VBA programming language to make your Excel spreadsheets much more powerful. This course starts out with the basics of VB programming and teaches on how to use it to its fullest potential within Excel.

The course extends past editing odd Macro, directly into creating custom scripts using the VBA Programming Language. You will also learn about VBA structures, the difference between Functions and Subroutines, how to manipulate Excel cells, interacting with the user, and very importantly, and error handling.

Course rating: 4.5 out of 5.0 ( 1,603 Ratings total)

In this course, you will learn how to:

  • make interactive and fully functional spreadsheets with the help of VBA programming.
  • understand VBA structures and the difference between Functions and Subroutines.
  • create custom scripts using the VBA Programming Language.
  • manipulate Excel cells.

You can take Visual Basic for Excel - Microsoft VBA Excel Tutorial Certificate Course on Udemy.

7. Excel VBA: Process Modeling

In this course, you will learn how to use Excel and VBA for business process modeling. You will learn how to use Excel and Visual Basic for Applications (VBA) to create and run simulations of business processes for customer flow, queuing, and manufacturing. VBA exponentially extends the power of Excel, allowing you to control process flow and logic and add custom classes and variables.

This course demonstrates how to build simulations of increasing complexity, which model the flow of customers through a multi-station process. Moreover, you will learn how to calculate arrival times, add customers, increase individual station capacity, and enable conditional station paths. At the end of the course, you will also learn how to convert the output to an Excel table and analyze the results of your simulation.

Course rating: 11,318 total enrollments

In this course, you will learn how to:

  • use Excel and VBA for business process modeling.
  • calculate arrival times, add customers, increase individual station capacity, and enable conditional station paths.
  • create and run simulations of business processes for customer flow, queuing, and manufacturing.
  • convert the output to an Excel table and analyze the results of your simulation.

The course includes:

  • Define Necessary VBA Constructs
  • Develop Process Control Structures
  • Add a Ticker to Track Time
  • Add Customers during the Simulation
  • Modify the Simulation
  • Allow Conditional Processing
  • Analyze Simulation Results

You can take the Excel VBA: Process Modeling Certificate Course on LinkedIn.

8. Master Excel VBA: Learn Programming for the Business Professional

In this course, you will learn how to program Excel using VBA macros. You will learn to automate and extend the Excel environment to supercharge your Excel models, automate routine tasks, customize your user interface, and manage large quantities of data.

Course rating: 4.6 out of 5.0 ( 2,944 Ratings total)

In this course, you will learn how to:

  • obtain practical fluency in Visual Basic for Applications (VBA).
  • automate and extend Excel by adding VBA projects.
  • enhance, customize, and extend the Excel user interface through modifications.

You can take Master Excel VBA: Learn Programming for the Business Professional Certificate Course on Udemy.

9. Developing for Excel with VBA

In this course, you will learn all about Visual Basic for Applications (VBA), the programming language built directly into Excel. You will find out what VBA is and how it became part of the Microsoft Office suite. More importantly, you will discover how VBA can be used to create user applications, querying a database to perform searches. You will also see how user interfaces can be built using Excel worksheets, and how buttons can be used to call your code.

Whilst all this is going on, you will learn how to structure and debug your code. Once you have built your first application, you will discover how to manipulate other Excel workbooks, inserting values, and saving the file as a PDF.

Course rating: 4.0 out of 5.0 ( 35 Ratings total)

In this course, you will learn how to:

  • understand VBA and how it became part of the Microsoft Office suite.
  • create user applications and query a database to perform searches with the help of VBA.
  • structure and debug your code.
  • manipulate other Excel workbooks, inserting values, and saving the file as a PDF.

You can take Developing for Excel with VBA Certificate Course on Pluralsight.

10. Excel VBA Programming - The Complete Guide

In this course, you will learn how to automate your Microsoft Excel workflow, accelerate your productivity, and master programming with VBA.

Course rating: 4.6 out of 5.0 ( 3,152 Ratings total)

In this course, you will learn how to:

  • automate tasks and procedures in Excel using Visual Basic for Applications (VBA).
  • utilize the objects in the Excel Object Model to emulate user actions in Excel.
  • react dynamically to user events like entering a cell value or opening a workbook.
  • feel comfortable with the fundamentals of computer programming.

The course includes:

  • The Excel Object Model
  • The Visual Basic Editor
  • Objects and Methods
  • Variables and Data Types
  • Writing Your Own Procedures
  • The Workbooks and Workbook Objects
  • The Worksheets and Worksheet Objects
  • Range References
  • Range Actions
  • Conditional Logic
  • Iteration
  • Alerts
  • Configuring Excel Functionality
  • Custom Functions
  • Arrays
  • Debugging
  • Even Procedures
  • User Forms

You can take Excel VBA Programming - The Complete Guide Certificate Course on Udemy.

11. Excel/VBA for Creative Problem Solving, Part 1

In this course, you will learn how to augment, expand, optimize, and increase the efficiency of your Excel spreadsheet skills by tapping into the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA).

Course rating: 4.8 out of 5.0 ( 2,133 Ratings total)

In this course, you will learn how to:

  • create macros to automate procedures in Excel.
  • define your own user-defined functions.
  • create basic subroutines to interface with the user.
  • gain skills like Microsoft Excel VBA, Computer Programming, Problem Solving, and Debugging.
  • understand 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.

You can take Excel/VBA for Creative Problem Solving, Part 1 Certificate Course on Coursera.

12. Excel/VBA for Creative Problem Solving, Part 2

In this course, you will learn how to augment, expand, optimize, and increase the efficiency of your Excel spreadsheet skills by tapping into the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA).

Course rating: 4.9 out of 5.0 ( 730 Ratings total)

In this course, you will learn how to:

  • work with arrays and import/export arrays from/to Excel using VBA code.
  • work with text strings and 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 as well as the import of information from multiple workbooks to a central workbook.
  • gain experience with creating professional user forms to interface with the user, perform advanced calculations and manipulate data on the spreadsheet.

You can take Excel/VBA for Creative Problem Solving, Part 2 Certificate Course on Coursera.


‌‌Hey! If you have made it this far then certainly you are willing to learn more and here at Coursesity, it is our duty to enlighten people with knowledge on topics they are willing to learn. Here are some more topics that we think will be interesting for you.