Excel VBA Programming - The Complete Guide

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

4.7|Reviews (6.2K)|verifiedIncluded in Subscription
radio_button_checkedPersonal Plan
₹375/mo
₹50025% OFF
Get this course and thousands more with a Personal Plan subscription.
radio_button_uncheckedIndividual Course
489340986% OFF
Keep the course forever with lifetime access and receive a certificate.
Team Plan₹2,000.00 a month per user
₹24,000/mo
Enterprise PlanCustom Pricing
Custom Pricing

Why choose Personal Plan?

check
28,000+ Courses
check
20,000+ Practice Exercises
check
9,000+ Top Instructors
check
Personalized Learning
verifiedGet this course for free with the Personal Plan subscription.
✓ Compare courses before making a decision
Check Latest Price →
Price may vary. Check latest price on provider site.

Course Insight

This course is best for absolute beginners with no programming experience who want to learn VBA basics in Excel.

Beginner FriendlyCertification FocusedSelf-Paced Learning

SKILLS TO
MASTER

Microsoft Basics
Fundamental principles and concepts
Practical ApplicationTrending
Real-world project implementation
Best Practices
Industry standard workflows and guidelines
Problem Solving
Core Concepts
Implementation
Workflow Integration
Optimization
Careers:Relevant for professionals pursuing roles within Microsoft.

Quick Facts

Below sections are verified from last major sync. For real-time updates and today's latest lectures, Check official page here.

What You’ll Learn

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!

See how this course curriculum compares with alternatives

Outcomes

  • 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.
See side-by-side differences in learning outcomes

Course Curriculum

18 sections • 159 lectures • 17h 58m total length

FAQs

Instructor

BP

Boris Paskhaver

4.7 Rating48,917 Reviews423,557 Students8 Courses
Boris Paskhaver Software Engineer | Consultant | Author Hi there, it's nice to meet you! I'm a New York City-based software engineer, author, and consultant who's been teaching on Udemy since 2016. Like many of my peers, I did not follow a conventional approach to my current role as a web developer. After graduating from New York University in 2013 with a degree in Business Economics and Marketing, I worked as a business analyst, systems administrator, and data analyst for a variety of companies including a digital marketing agency, a financial services firm, and an international tech powerhouse. At one of those roles, I was fortunate enough to be challenged to build several projects with Python and JavaScript. There was no formal computer science education for me; I discovered coding entirely by accident. A small work interest quickly blossomed into a passionate weekend hobby. Eventually, I left my former role to complete App Academy, a rigorous full-stack web development bootcamp in NYC. The rest is history. I've always been fascinated by the intersection of technology and education, especially since I've struggled with many of the traditional resources people use to learn how to program. My goal as an instructor is to create comprehensive step-by-step courses that break down the complex details into small, digestible pieces. I like to build the kind of material that I myself would have loved to have when I was starting out. I'm passionate about teaching and would love to help you discover what code can do for you. See you in a course soon!

Reviews

4.7 / 5 average rating from 6.2K+ learners

View detailed reviews on Udemy
Unsure about these reviews? Compare with other top courses

Deals

This course is currently available at a discounted price  489 3409 (86% OFF)  on Udemy. Udemy also offers deals on other courses from time to time — click below to explore

Explore Deals on Udemy →

Deals and prices are set by the provider and may change. Please check final details on the provider’s site.

Top Alternatives

Highly-rated courses worth your attention

Introduction to Microsoft Excel VBA
4.6· 4h 16m
Beginner
₹519₹2,79981% OFF
Master Excel VBA & Unlock Business Programming Solutions
4.6· 15h 50m
Beginner
₹519₹2,85982% OFF
Microsoft Word VBA Macro Programming - Introduction
4.7· 12h 56m
Beginner
₹579₹3,69984% OFF
The Ultimate Excel VBA Course: Learn & Master VBA Fast
4.4· 2h 37m
Beginner
₹449₹2,02978% OFF
Excel VBA - The Complete Excel VBA Course for Beginners
4.6· 12h 19m
Beginner
₹609₹4,15985% OFF
Advanced Microsoft Word VBA Macro Programming
4.4· 13h 13m
Advanced
₹479₹2,89983% OFF
Excel VBA Programming - The Complete Guide
4.7(6.2K+ learners)