Microsoft Excel VBA for Beginners - Learn VBA Step by Step

Focused View

Steve McDonald,Gillian Werner

5:31:41

11 View

1. Introduction - What Youre Going to Learn in This Course.mp4

02:07

2. What is VBA and When is it Used.mp4

04:34

3. How to Set Up VBA in Excel.mp4

05:04

4. Understanding the Basics of VBA.mp4

04:34

5. How to Record a Simple Macro.mp4

04:23

7. Creating a Sub.mp4

04:25

8. Variable Types.mp4

05:42

9. Declaring a Variable.mp4

11:09

10. Creating Dialogs.mp4

12:12

11. Introduction to Arrays.mp4

05:14

12. Static Arrays.mp4

08:18

13. Dynamic Arrays.mp4

10:19

14. Multi-Dimensional Arrays.mp4

11:59

15. Controls.mp4

10:22

16. Object Hierarchy.mp4

05:06

17. Workbooks - Part 1.mp4

09:52

18. Workbooks - Part 2.mp4

11:40

19. Worksheet Objects.mp4

12:40

20. Reading and Writing Data.mp4

12:10

21. Tables.mp4

10:36

22. Table Interactions.mp4

12:52

23. Math Manipulation.mp4

09:58

24. String Manipulation.mp4

11:33

25. Creating and Calling a Subroutine.mp4

04:27

26. Passing Arguments.mp4

07:46

27. Types of Loops and If Statements.mp4

05:10

28. WithEnd With.mp4

04:20

29. Loop Examples.mp4

12:25

30. Controls.mp4

14:20

31. Properties.mp4

09:20

32. Form Code.mp4

19:57

33. Loading a Form and Preparing Lists.mp4

06:35

34. Speeding Up Your Code.mp4

08:43

35. Error Types.mp4

03:59

36. Debugging.mp4

10:30

37. Error Handling.mp4

07:40

38. Custom Functions.mp4

07:47

39. Custom Events.mp4

09:41

41. Conclusion.mp4

02:12

Description

Serious about learning VBA for Excel? This course makes learning VBA easy. Jump in and master Microsoft Excel VBA today!

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

Who is this 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

What You Need to Know?

Students should have a good basic understand of how to use Excel

No previous coding or VBA experience is needed

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

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

Instructor's Courses

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

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.