Learn Microsoft Excel VBA Macros for Beginners

Automate mundane tasks with Microsoft Excel VBA & Excel Macros and become your company's hero!

4.70 (15 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
54
students
3.5 hours
content
Jan 2021
last update
$59.99
regular price

What you will learn

Master Excel VBA & Macros

Make your work-life WAY easier

Automate routine tasks within Excel

Write custom VBA code to automate your Excel tasks

VBA programming concepts to create dynamic, re-usable code

Coding best practices

Complete real world Macro/VBA projects from beginning to end

Description

By the end of this course, you will go from knowing nothing about VBA Macros to knowing how to do the most common functions...all within 3.5 hours!

Any version of Excel is supported.

Excel VBA Macros are one of the most powerful features in Excel. Why? Because Macros can help you automate almost any routine task, saving you hours and hours of time.

During this course, we start with the very foundations of VBA Macros and slowly build your quiver of knowledge. We only teach you the most important functions, functions that can help you accomplish almost any task in VBA.

Our instructors have years of experience working with leading companies (like Puma) and universities (like Harvard) to help them automate their spreadsheets. We've also taught hundreds of professionals around the U.S. these amazing skills. After all of this, we know what you need to know to get started.


Absolutely ZERO background in VBA or programming is necessary!


Some key things you’ll learn:​

  • Learn the structure of VBA code and best practices

  • Create sub routines to segment your code​

  • Declare and call variables​

  • Create For /Next loops​

  • Create If/Then and If/Then/Else logical tests​


What makes our course so awesome?

  • Real world application: In depth, real-world case studies

  • Fun: Light-hearted, fun, and enjoyable course (we never take ourselves too seriously)

  • Knowledgeable instructor: Nate has spent his entire career mastering Excel, consulting companies in Excel, and teaching Excel.

  • No fluff: We don’t teach theory or waste your time with useless information. Everything we teach you can start applying TODAY


Let's start learning!

Content

Welcome

Welcome to the course!
Course materials

Intro to VBA Coding

Preparing your workbook for macros
The Developer tab
VBA project view
Code syntax pt. I
Code syntax pt. II
Code formatting
Quiz 1

VBA Code Basics

Referencing a worksheet
Referencing a range
Clearing a cell's contents
Copy and paste method #1
Copy and paste method #2
Declaring a variable pt. I
Declaring a variable pt. II
Message boxes pt. I
Message boxes pt. II
Quiz #2

Named Ranges & If Statements

Naming & referencing a named range
Setting a range as a variable
Finding the last row of data pt. I
Finding the last row of data pt. II
Offset
If statements pt. I
If statements pt. II
Quiz #3

For/Next Loops & Making Our Code Dynamic

For/Next loops pt. I
For/Next loops pt. II
Making our code dynamic pt. I
Making our code dynamic pt. II
Making our code dynamic pt. III
Quiz #4

Recording and Manipulating a Macro

3 suggestions for learning VBA code
Recording a macro
Manipulating a recorded macro pt. I
Manipulating a recorded macro pt. II
Quiz #5

Real-World Case Study

Introduction to the case study
Creating a Yes/No message box
Finding the first and last rows
Adding For/Next loops w/ an If statement
Making our macro more dynamic
Repurposing our code pt. I
Repurposing our code pt. II
Reviewing what we've learned
Quiz #6

Conclusion

Wrapping up!

Screenshots

Learn Microsoft Excel VBA Macros for Beginners - Screenshot_01Learn Microsoft Excel VBA Macros for Beginners - Screenshot_02Learn Microsoft Excel VBA Macros for Beginners - Screenshot_03Learn Microsoft Excel VBA Macros for Beginners - Screenshot_04

Reviews

Kaustubh
April 8, 2023
Trainer Nate knows how to simplify a difficult topic. VBA is vast vast subject. What Nate has done is picked up bare essentials of VBA and taught by using mini case lets. This has helped to keep the videos small yet effective. I would want Nate to create a new VBA Level two real life case studies based course which covers wider variety of VBA Functions. By the way Nate has mastered the art of delivering course in such a way as if the trainer is teaching to his best friend. I would definitely recommend this VBA course for new comers into VBA.

Charts

Price

Learn Microsoft Excel VBA Macros for Beginners - Price chart

Rating

Learn Microsoft Excel VBA Macros for Beginners - Ratings chart

Enrollment distribution

Learn Microsoft Excel VBA Macros for Beginners - Distribution chart

Related Topics

3770830
udemy ID
1/13/2021
course created date
1/16/2021
course indexed date
Bot
course submited by