Introduction to Microsoft Excel VBA (Udemy.com)
Learn Microsoft Excel VBA Fundamentals (Excel 2010, 2013, 2016)
Created by: Kyle Pew
Last updated November 2017
What you will learn
- Fundamental Building Blocks of Using Excel VBA to Automate Routine Tasks
- How to Implement Excel VBA into an Excel Workbook
- Become Familiar with Common Excel VBA Programming Syntax
- Work with VBA Variables, Conditional Statements, and Loops
- Learn the Differences Between Absolute and Relative References to Create Dynamic Code
- Debug Code Effectively
- Interact with and Receive Input from Users
- Learn Microsoft Excels VBA Object Structure
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.7 out of 5higher than 81% of them
- Reviews1,675#125 of 356 by number of reviews
- Length4.3 hoursshorter than 61% of them
- Last updatedNovember 2017earlier than 85% of them
Course Description
Microsoft Excel VBA (Visual Basic for Applications) provides Excel users with the ability to automate any Excel task. Excel Tasks that would normally take an extensive amount of work and time to complete can ultimately be automated and completed in a single click of a button. All that's needed to automate your experience is a little Excel VBA knowledge.
Maybe you've heard of Excel Macros and VBA. Or, maybe you've even attempted to create your own. Jumping into VBA can be a bit daunting and overwhelming. I've been teaching Excel for 15+ years and have had loads of questions from those that have taken the dive into learning Excel VBA. Where should I start? What do I need to know? What's a variable? Enroll in this course and I'll share the knowledge and experience I've gained working with Excel VBA.
WHAT YOU'LL LEARN
- Fundamentals of Excel VBA
- Proper Syntax Writing VBA Code
- Excel Object Structure to Effectively Communicate with Excel
- Working with the Most Common VBA Objects in Excel
- Automate Routine Microsoft Excel Tasks
- And More....
EXERCISE FILES AND QA
As you go through the video lectures you can download the exercise files, found within each section. Use the exercise files to practice the concepts you will be learning.
The course contains a QA section where you can interact with me and ask any questions as you develop your VBA skills.
ENROLL NOW
As you participate in this introductory Excel VBA course you will build the knowledge and confidence to automate your experience in Excel, saving you time and money.
Instructor Details
- 4.7 Rating
1,675 Reviews
Kyle Pew
Welcome! I'm Kyle Pew, a Microsoft Certified Trainer (MCT), Microsoft Office Master Instructor, and Udemy Instructor Partner, with over 20 years of experience training over 2 million students in Microsoft Office and beyond. I’m passionate about helping students of all backgrounds and skill levels succeed in using tools like Excel, Word, PowerPoint, Access, and more, as well as diving into advanced topics like VBA and SharePoint.
With a background in media arts and animation from the San Francisco Art Institute and industry experience as a game designer at Electronic Arts, I bring a unique perspective to my training. My clients have included major corporations like Chevron, Facebook, Walmart, and many more, delivering training to both large-scale audiences and individuals, adapting each lesson to address real-world applications. My courses are built around the principle that the best way to learn is by tackling real-life challenges—allowing you to build confidence and problem-solving skills.
Join me on Udemy and let’s take your skills to the next level. When I’m not teaching, I’m enjoying time with my six children or cheering on my favorite hockey team, the San Jose Sharks.
More courses by Kyle Pew
Microsoft Excel - Excel from Beginner to Advanced 2026
4.7 (543,696 Reviews)
Provider: Udemy
Time: 22.3h
$139.99
Master Microsoft Excel Macros and Excel VBA (2025)
4.6 (33,954 Reviews)
Provider: Udemy
Time: 5.4h
$15.99
Master Microsoft Word Beginner to Advanced (2019)
4.7 (32,671 Reviews)
Provider: Udemy
Time: 7h
$18.99
Microsoft PowerPoint From Beginner to Advanced (2019)
4.6 (24,824 Reviews)
Provider: Udemy
Time: 6.8h
$14.99
Microsoft Excel Data Analysis and Dashboard Reporting (2018)
4.6 (13,525 Reviews)
Provider: Udemy
Time: 3.6h
$15.99
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
By Donald Porretto on 6/13/2026
Kyle took his time explaining each new concept in the course and didn't rush through it. I especially liked the depth of his explanations and the challenges that he presented us with which really helped to reinforce the learning experience.
By Lee Francis on 1/23/2026
Completed this in 2026, its very good with the introductions. Its built as if you know nothing about VBA, which I didnt. It was methodical, logical and steady. By the end I was able to understand and complete all the things Kyle went over. And Kyle is still answering questions! so its not "dead"
By Udemy User on 1/3/2026
this is a good course with great content, but I'm struggling so far to see the benefit of coding to delete or rename a sheet within a workbook when this can be easily done with a right click. Although I do recognise the importance of learning how to check the sheet count in case of hidden sheets, the rest of this seems so far to be extra steps to do simple tasks. Hopefully this is just the foundation so far and it's helping to lay the foundations for the rest of the course.
By Ümit Karahan on 12/12/2025
It is a nice, brief introductory course. You need to put some more extra practice or advanced courses on it if you want to go deeper. For those who have less time but again want to have some insight about VBA in Excel, this course is a great choice.
By Javier Gonzalez on 11/12/2025
I expected examples of applications on Excel sheets
By Anna Mi Norina on 2/11/2025
the best course for complete beginner with 0 prior knowledge so far. It is very hard to start learning new skill to lay foundation of undertanding to improve to the next level. often times we stop because we just dont get the basic let alone continue to deeper and more detail, but this course is so good at teach the basic understanding of the context of Macros.
By Nicolene Baker on 1/19/2021
I work with Excel daily but have had no prior training on it. This course has helped me so much to work more efficiently. The instructor makes all the concepts very easy to understand, and this course has added tremendous value to my life and has made daily tasks so much quicker and easier to handle. Thanks for a great course, will definitely be recommending it to my colleagues.
By Abdullah Kasabji on 11/14/2020
Little bit slow.. but still explaining the concepts pretty good .
By Michael Tran on 11/1/2020
Clearly explained!
By Dale Thompson on 10/23/2020
I found the course very helpful.
By Dilip Wickremasinghe on 10/22/2020
Excellent!
By Peter Lim on 10/16/2020
gr8 intro to vba
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 94 / 100












