bestcourses is supported by learners. When you buy through links on our website, we may earn an affiliate commission. Learn more

Excel VBA Programming - The Complete Guide

Automate your Microsoft Excel workflow, accelerate your productivity, and master programming with VBA! Beginners welcome

4.68 / 5.0
64261 students17 hours 58 minutes

Created by Boris Paskhaver, offered on Udemy

bestcourses score™

Student feedback

9.2/10

To make sure that we score courses properly, we pay a lot of attention to the reviews students leave on courses and how many students are taking a course in the first place. This course has a total of 64261 students which left 4218 reviews at an average rating of 4.68. Impressive!

Course length

8.9/10

We analyze course length to see if courses cover all important aspects of a topic, taking into account how long the course is compared to the category average. This course has a length of 17 hours 58 minutes, which is pretty short. This might not be a bad thing, but we've found that longer courses are often more detailed & comprehensive. The average course length for this entire category is 5 hours 28 minutes.

Overall score

9.0/10

This course currently has a bestcourses score of 9.0/10, which makes it a great course to learn from. On our entire platform, only 15% of courses achieve this rating!

Description

Welcome to Excel VBA Programming - The Complete Guide, Udemy's most comprehensive VBA course!

Visual Basic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications like Excel, Access, and Outlook. It allows developers to write procedures called macros that perform automated actions. Anything that you can do in Excel, you can automate with VBA!

Over the course of more than 18 hours of content, we'll cover VBA from the ground up, beginning with the fundamentals and proceeding to advanced topics including:

  • 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

In addition to the video content, the course is packed with dozens of quizzes, challenges, and assignments to test your knowledge of your material as you progress.

No programming experience is required -- complete beginners are more than welcome! VBA is a great language to start with because you can master the fundamentals of programming in a familiar work environment.

No extra software is necessary - VBA is bundled with all modern versions of Excel.

Excel is the world's most popular spreadsheet software and is available on over 750 million computers worldwide. Whether you use it for professional or personal reasons, VBA can help you remove the redundancy in your workflow and accelerate your productivity drastically!

Thanks for checking out the course!

What you will learn

  • 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

Requirements

  • A modern version of Microsoft Excel for Windows (2016 is strongly recommended)
  • Intermediate knowledge of popular Excel features (functions, PivotTables, charts, etc.)
  • Basic knowledge of data types (numbers, strings, Booleans, dates)
  • A desire to learn!
Udemy logo
Available on

Udemy

With almost 200,000 courses and close to 50 million students, Udemy is one of the most visited online learning platforms. Popular topics include software development, the digital economy, but also more traditional topics like cooking and music.

Frequently asked questions

  • Price: $19.99
  • Platform: Udemy
  • Language: English
  • 17 hours 58 minutes
Excel VBA Programming - The Complete Guide thumbnail

bestcourses score: 9.0/10

This course is one of the best in its category!