Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Life Purpose Meditation Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel VBA

Microsoft Excel VBA for Beginners - Learn VBA Step by Step

Serious about learning VBA for Excel? This course makes learning VBA easy. Jump in and master Microsoft Excel VBA today!
Rating: 4.4 out of 54.4 (258 ratings)
24,192 students
Created by Steve McDonald, Gillian Werner
Last updated 6/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn Excel VBA from beginner to advanced skills
  • Use VBA to save time by automating tedious tasks
  • Get valuable hands-on experience so you can use VBA in your daily work

Requirements

  • Students should have a good basic understand of how to use Excel
  • No previous coding or VBA experience is needed

Description

Welcome to the Excel VBA Programming Course for Beginners. If you need to learn how to program VBA for your job or for yourself, this course was designed for you!

You'll start with the very basics of understanding what VBA is and what it does. You'll learn how to install VBA and record your first macro. Then, you'll progress to learning all of the essential terminology as you create your own functional VBA modules. By the end of this course, you'll be able to create your own user forms that other users can interact with and enter data into, and you'll be able to troubleshoot and debug your code, make it run faster, and even create your own custom Excel functions.

The beauty of VBA is that when you learn to master it, you can program Excel to do the work for you.

Using VBA, you can save a ton of time for your organization by automating repetitive and tedious tasks.

VBA isn't exactly easy, but it's one of the simplest and easiest to learn programming languages. It's like the gateway drug that gets you hooked on programming. And in this course, I'll walk you through the initial learning curve to give you a solid foundation from which to launch your programming skills.

This is a very detailed course and you will walk away with a vastly expanded vocabulary and a full toolbox of VBA programming skills.

The truth is, you could  teach yourself VBA using free articles and videos on the internet. The challenge is that VBA can be hard to learn without the right info and the right examples. It's easy to waste a lot of time learning things that aren't useful in the real world. By following this course, you'll get clear, step-by-step guidance along a relevant and valuable learning path to master the essentials of Excel VBA.

I have a lot of personal experience learning and using VBA as an engineer and I'm very excited to pass that knowledge on to you! Ever since my days as a college tutor, I've loved teaching and helping people learn challenging subjects. So, if you're ready to learn how to start programming in Excel VBA, I'm excited to show you how!

Thanks for checking out the course and I'll see you in the first lesson.

By the way, did I mention that Udemy has a 30-day money back guarantee? That's right. You can take the whole course, and if in those first 30 days you don't feel like you're actively getting better at using VBA, you can get a full refund. So, you really have nothing to lose. Dive in and start learning Excel VBA today!


Who this course is for:

  • Beginning VBA users with no prior VBA experience
  • Intermediate Excel users who are ready to super charge their efficiency
  • Anyone who needs to add valuable job skills to become more competitive in the workplace

Featured review

Robert Wilby
Robert Wilby
253 courses
49 reviews
Rating: 5.0 out of 510 months ago
Great course for anyone who is new to VBA or like me returning to VBA after a long time away. Topics were clearly discussed and explained in detail. Starts with the basics and from this goes on to build a form and continues to explain speeding up code as well as good practice in debugging. A nice addition was a demonstration of how to create a function and apply it. All in all, good tips and well presented. Support is very good too, if you have any questions.

Course content

11 sections • 40 lectures • 5h 32m total length

  • Preview02:07
  • Preview04:34
  • Preview05:04
  • Preview04:34
  • Preview04:23
  • 3 Valuable Help Resources
    00:25

  • Preview04:25
  • Variable Types
    05:42
  • Declaring a Variable
    11:09
  • Creating Dialogs
    12:12
  • Introduction to Arrays
    05:14
  • Static Arrays
    08:18
  • Dynamic Arrays
    10:19
  • Multi-Dimensional Arrays
    11:59
  • Controls
    10:22

  • Object Hierarchy
    05:06
  • Workbooks - Part 1
    09:52
  • Workbooks - Part 2
    11:40
  • Worksheet Objects
    12:40
  • Reading and Writing Data
    12:10
  • Tables
    10:36
  • Table Interactions
    12:52

  • Math Manipulation
    09:58
  • String Manipulation
    11:33

  • Creating and Calling a Subroutine
    04:27
  • Passing Arguments
    07:46

  • Types of Loops and If Statements
    05:10
  • With/End With
    04:20
  • Loop Examples
    12:25

  • Controls
    14:20
  • Properties
    09:20
  • Form Code
    19:57
  • Loading a Form and Preparing Lists
    06:35

  • Speeding Up Your Code
    08:43

  • Error Types
    03:59
  • Debugging
    10:30
  • Error Handling
    07:40

  • Custom Functions
    07:47
  • Custom Events
    09:41

Instructors

Steve McDonald
Dedicated Instructor Will Help You Excel | 300K+ Students
Steve McDonald
  • 4.5 Instructor Rating
  • 28,136 Reviews
  • 389,945 Students
  • 21 Courses

Learning is easier with the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals. 

My talent is taking complex subjects (like Excel, Access and Photoshop) and making them simple to learn. I wasn't always good at technology. There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated myself to mastering technology. Now I'm proud to call myself a self-taught tech geek. 

I'm a geek who still speaks the language of normal human beings. I don't use a lot of jargon and fancy words that the average person doesn't understand.

I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery.

I am here to guide you on your way to success. You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction.

I'm always happy to help.  I believe in you, and I'm here to support you in your learning process.

Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy.

Sign up for a course today and I'll help you reach the level of success you deserve. 

I'll see you in there!

Gillian Werner
Engineer and Software Developer
Gillian Werner
  • 4.4 Instructor Rating
  • 258 Reviews
  • 24,192 Students
  • 1 Course

I am an aerospace engineer with experience in military aviation and additional knowledge in software development, automation, and database development.  I found my passion for teaching as a tutor for various engineering courses while in school, and have continued teaching via online outlets since graduation.  I look forward to sharing my knowledge with others through Udemy!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.