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+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Neuroscience Coaching
Web Development JavaScript React CSS Angular PHP Node.Js WordPress 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 Google Analytics
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 Freelancing Blogging 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

This course includes:

  • 18 hours on-demand video
  • 4 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
Office Productivity Microsoft Excel VBA

Excel VBA Programming - The Complete Guide

Automate your Microsoft Excel workflow, accelerate your productivity, and master programming with VBA! Beginners welcome
Rating: 4.6 out of 54.6 (3,552 ratings)
61,388 students
Created by Boris Paskhaver
Last updated 9/2020
English
English [Auto], Indonesian [Auto], 
30-Day Money-Back Guarantee

What you'll 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!

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!

Who this course is for:

  • Spreadsheet users who want to automate their daily workflow
  • Business analysts who want to remove redundancy from their common tasks
  • Excel users who are curious about exploring programming in a familiar work environment

Featured review

Marco Antonio Garza Gómez
Marco Antonio Garza Gómez
7 courses
3 reviews
Rating: 5.0 out of 55 months ago
It's really well explain, the teacher puts attention to every detail, so you dont have any doubts along the sections, and you really feel confident when doing the assignments cause it's easy to understand the VBA logic.

Course content

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

  • Preview13:08
  • About Me
    00:56
  • Download Course Materials
    00:42
  • Preview07:06
  • Excel File Types
    04:00
  • Macro Security
    08:43
  • The Macro Recorder
    15:12
  • Record Macro to Change Worksheet Orientation
    2 questions
  • Absolute vs. Relative References I
    08:12
  • Absolute vs. Relative References II
    08:14
  • The Visual Basic Editor
    09:01
  • VBA Basics
    7 questions

  • Preview11:29
  • Real Life Objects
    3 questions
  • Collection Objects in Real Life
    05:50
  • Objects As Properties
    09:08
  • The Excel Object Model
    13:34
  • Access Object from Collection by Name
    03:57
  • Default Properties
    03:38
  • The Name Property on Workbook and Worksheet Objects
    04:03
  • Object-Oriented Programming
    6 questions

  • Visual Basic Editor Options
    13:39
  • Preview08:51
  • Procedures
    5 questions
  • The Immediate Window and Debug.Print Method
    08:45
  • The MsgBox Method
    13:34
  • Comments
    05:18
  • Practice with Procedures
    6 questions
  • The Visual Basic Editor
    11 questions

  • Methods without Arguments
    03:28
  • Methods without Arguments
    3 questions
  • Methods with Arguments
    08:30
  • Methods with Arguments
    3 questions
  • Methods with Multiple Arguments
    06:42
  • The Object Browser
    05:28
  • Ways to Invoke A Procedure
    08:17
  • The TypeName Method
    05:53
  • Objects and Methods
    9 questions

  • Syntax Tips
    07:37
  • Variable Declarations and Assignments
    10:01
  • Multiple Variable Declarations
    04:14
  • The Option Explicit Setting
    05:52
  • The Byte, Integer and Long Data Types
    07:54
  • Numeric Data Types
    3 questions
  • Mathematical Operations
    06:06
  • The Single and Double Data Types
    05:59
  • The String Data Type
    04:58
  • String and Double Data Types
    5 questions
  • The Boolean Data Type
    04:24
  • The Date Data Type
    06:22
  • The Variant Data Type
    05:42
  • The Object Data Type
    08:04
  • Default Values for Declared Variables
    02:53
  • Variable Declarations
    2 questions

  • Variable Scope
    09:30
  • Call A Procedure from Another one
    03:54
  • Procedures with Arguments
    07:15
  • Procedure Scope (Public vs. Private)
    06:54
  • The Exit Sub Keywords
    01:49
  • Constants
    06:48
  • Preview11:00
  • Procedures
    6 questions

  • The Application Object
    04:14
  • The Application.DisplayAlerts Property
    06:26
  • The Workbooks.Count and Worksheets.Count Properties
    02:07
  • The Workbooks.Open Method and Workbook.Path Property
    06:59
  • The Workbooks.Close Method
    01:47
  • The Workbooks.Add Method
    05:56
  • The Workbook.SaveAs and Workbook.Save Methods
    09:31
  • The Workbook.Activate Method
    06:58
  • The Workbook.Close Method
    04:13
  • The Application, Workbooks and Workbook Objects
    6 questions
  • The Worksheets.Add Method
    05:27
  • Add a New Worksheet to End of Current List of Worksheets
    1 question
  • The Worksheet.Visible Property
    05:11
  • The Worksheet.Copy Method
    03:34
  • The Worksheet.Delete Method
    02:24
  • The Worksheet.Move Method
    02:58

  • Preview08:42
  • The Value vs. Text Properties
    03:50
  • R1C1 Notation, Part I
    09:53
  • R1C1 Notation, Part II
    07:55
  • The Formula and FormulaR1C1 Properties
    06:47
  • The Range.Offset Property
    05:05
  • The Range.Resize Property
    03:53
  • The Offset and Resize Properties
    10 questions
  • The Cells Property
    04:43
  • The Range.CurrentRegion Property
    05:00
  • The Range.End Property
    08:24
  • The Range.Count and Range.CountLarge Properties
    03:20
  • The Range.Row and Range.Column Properties
    02:25
  • The Range.Rows and Range.Columns Properties
    06:59
  • The Range.EntireRow and Range.EntireColumn Properties
    02:54
  • Get Last Row of Data in Worksheet
    06:23

  • The Range.FillDown Method
    05:01
  • The Range.Replace Method
    04:42
  • The Range.TextToColumns Method
    09:28
  • The Range.Worksheet Property
    02:09
  • The Range.Sort Method
    12:32
  • The Range.Font Property
    09:07
  • The Range.Interior Property
    06:41
  • The Range.ColumnWidth and Range.RowHeight Properties
    06:27
  • The Range.AutoFit Method
    02:58
  • The Range.Clear, Range.ClearContents and Range.ClearFormats Methods
    04:02
  • The Range.Delete Method
    05:53
  • The Range.Copy and Range.Cut Methods
    04:00
  • The Paste and PasteSpecial Methods on the Worksheet Object
    04:56
  • The Parent Property on All Objects
    04:23

  • Boolean Expressions
    06:27
  • Boolean Expressions
    9 questions
  • The If Then Statement
    04:05
  • The ElseIf and Else Statements
    10:41
  • Select Case
    10:41
  • The AND & OR Logical Operators
    06:34
  • Logical Operators
    14 questions
  • The NOT Operator
    07:27

Instructor

Boris Paskhaver
Software Engineer | Consultant | Author
Boris Paskhaver
  • 4.7 Instructor Rating
  • 23,349 Reviews
  • 289,727 Students
  • 6 Courses

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!

  • 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.