Excel VBA Programming - The Complete Guide

Name: Excel VBA Programming - The Complete Guide
Rating: 4.6 (4246 reviews)

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

(4,246 ratings)

64,470 students

Created by Boris Paskhaver

Last updated 4/2022

English

English [Auto], Indonesian [Auto],

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

10 courses

4 reviews

a year 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.

Boris Paskhaver

Software Engineer | Consultant | Author

4.7 Instructor Rating
32,288 Reviews
329,750 Students
7 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!