Learn Excel VBA Programming [Practical Tutorial for Building Excel Macros]

[Excel VBA Tutorial] Learn Excel VBA programming through actual code. This is an absolute beginner's course. Become a Beginner to Intermediate Excel VBA developer by the end of this tutorial/ project. In this course, we will build a 100% automatic real-world reporting process using Excel VBA.

#vba #learnvba #excelvba #excel #exceltutorial #exceltips

This tutorial is designed to take you straight to the heart of Excel VBA. Learn basic concepts such as Object hierarchy, Variables and how to setup your VBA coding environment. As we start to code the project, we will learn to manipulate Excel to our will e.g. Copy/ Paste Data, Open/ Close files. After that, we will go straight into cool VBA programming concepts such as If statements, For Loops. Finally, we will send an Outlook email with attachments using Excel VBA.

The most important gain is the bits of knowledge scattered through the course. I will be sharing invaluable Excel VBA tips and tricks from my own experience that will help you build your code safely and confidently.

And there are a whole lot of resources available to you outside this video. A blog post has been created that summarizes the theory sections in the tutorial and offers commentary on the Excel VBA code from the project. You can also, download full code covered in this tutorial here, and use it your very own project.

Good luck on your coding journey to becoming a VBA programmer!

Code:
You can find all the summarized concepts and full code at the bog post for this video.
https://skillsandautomation.com/project/learn-excel-vba-programming/

Files:
All files shown in this video are available to download from GitHub.
https://github.com/skillsandautomation/VBA-Beginner-Project-End-to-End-Reporting-Process

Extra Learning:
Link for Sending Emails covered in this video.
https://skillsandautomation.com/how-to/how-to-send-basic-outlook-email-using-excel-vba/

00:00 Intro
02:26 Concepts Covered
04:02 Course Resources
06:20 Video Layout
07:50 Scenario
09:12 Automation Approach
11:54 Demo
21:58 Setup Developer Ribbon
23:25 Setup VB Editor
26:05 First Hello World Macro
27:58 Saving Macro Files
29:12 Object Hierarchy
35:02 Object Properties and Methods
37:12 Variables
45:29 Macro 1: Import Data
01:13:04 Macro 2: Create Report Copy
01:29:38 Macro 3: Send Email
01:51:35 Run First 3 Macros Together
01:52:45 Macro 4: Error Handling
02:25:29 Macro 5: Combined Macro 100% Automation