Excel 2021 VBA Full Course Tutorial (6+ Hours)

preview_player
Показать описание
Excel 2021 VBA Full Course Tutorial (6+ Hours)

Get Ad-Free Training by becoming a member today!

Who it's for: Business Analysts, Data Scientists, and everyone in between looking to write their own rulebook on what’s possible in Excel.

What it is: Visual Basic for Applications (VBA) is the programming language for Excel and other Microsoft Office programs. VBA is used to automate repetitive processes and frequent actions. Even more, it can be used to build tools that otherwise don’t exist in Excel.

What you'll learn: In this 4-part series, we start with an overview of VBA and its advantages over recording macros in the Excel interface. We'll record a macro, which produces VBA code in the background, and learn the Visual Basic editor environment before editing the code generated by our macro. Throughout this section, you will learn some key terminology that will help you along the way. We will end the first lesson with saving a macro-enabled workbook and modifying trust center settings pertaining to macro security. You'll understand the Excel Object Model, collections, and how to reference objects in VBA code. Next, we'll go over different types of procedures, creating procedures, learning the scope of procedures, and working with methods. You will also learn how to get VBA context-specific help from within the editor. A key component of VBA is language elements. We will learn about this important topic by going over variables, their scope, and how to declare them. You will also gain an understanding of VBA data types, intrinsic functions, and the With-End With structure and how it provides efficiency in your code. You will also learn to create message boxes and input boxes in this lesson, as well as gain an understanding of object variables. The next lesson will teach you how to control program flow through supported control-of-flow structures. This lesson begins with an overview of structures and Boolean expressions. You will then learn how to utilize conditional branching, with the lesson ending with looping constructs. We move into creating forms, including properties, programming, controls, events, and methods. You will ultimately launch a form with code. The next lesson will take you through the steps necessary to create a Pivot Table programmatically in VBA. We end debugging and how to write error-handling code. By the end of this training series, you will be equipped to write your own VBA code, modify macros you’ve recorded, and create efficiency in your daily tasks with VBA.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
VBA Basics 0:03
Excel Object Model Hierarchy and Collections 47:52
Modules and Procedures 58:46
Variables, Data Types, and Intrinsic Functions 1:47:37
Object Variables 2:40:25
Controlling Program Execution 2:58:06
Forms and Controls 4:08:10
Pivot Tables 4:53:49
Debugging Code 5:43:40
Conclusion 6:42:16

#excelvba #exceltutorial #vba #exceltips #excel #visualbasic

(C) 2023 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.
Рекомендации по теме
Комментарии
Автор

Watched both the 2019 and 2021 versions and learned a lot... very comprehensive. There were a few recording and consistency issues (edits that repeated content, undefined terms, inconsistent variable names), but my real issue was that I think the pace changed considerably around Lesson 6. A lot of the code explanations disappeared (more like overviews of the imported files) and assumptions were made about the learner's grasp of the concepts presented earlier. Strategic choice to save time, but I found the last few lessons more difficult to follow because of this. Still, a tremendous effort and an amazing bargain (FREE!). Thanks.

catboy
Автор

Excellent course, well-structured and well presented. Awesome job Trish!

DAGenao
Автор

Hi Trish,

I'm halfway through the course and I'm loving it so far. Thank you so much for your clear explanations! I have a suggestion that might help improve the course. Sometimes, it would be beneficial to include brief quizzes or questions on the material we've just covered. Additionally, providing a moment to think about the answers before revealing them would be very helpful. These techniques can enhance learning and retention through active engagement and reflection.

Thanks again for the quality of your course. I hope this feedback is helpful.

Best regards !

alexflame
Автор

Great initiative trish.explain to the point and concise.

junaidtanoli
Автор

The voice is very relaxing, I can easily follow the exercises.

louieandrofuertes
Автор

Excellent course. Thank you very much for making it available on YouTube. Where can I get the class slides?

farzadshirani
Автор

I can't believe I have completed this complete 7 hours lecture in just 5 days. So much organized way of teaching which made me interested in learning.
One thing I want to ask that how we can learn and know the syntax of codes? any easy methods of it? If yes please do tell me. Thank you

rexomath
Автор

very well expained and structured course . Thanks for your efforts

letmedieyou
Автор

I really appreciate your effort in producing this stunning video ❤

GiangPham-fwkf
Автор

Hi I loved your video. I am also a VBA programmer and just started a channel teaching how to work with opengl in Excel through VBA

claudineyribeiro
Автор

Excellent! I loved the whole presentation. I have one question about declaring variables in a single line. My experience as been that if separate each variable by a comma and then add "as integer" at the end of the line, Only the last variable is declared properly. The others are declared as variant. What am I doing wrong?

nbforme
Автор

I really enjoyed the course. How do I access the slide deck?

JamesWray-rb
Автор

Hi! Thank so much for this course. I am wondering where i am able to find the presentation slides

animust
Автор

3:20:50. I believe you've omitted this line YearMarker = Mid (VinNum, 11, 1)
which made me confused for a while. Anyway, great lessons!! Thank you

anhlenguyen
Автор

Great Course. Am I the only one who cant find the slide deck?

MyBWR
Автор

I tried to type as you "GetNewInventory" at moment 1:30:33 and when I complied the file I have an error: Ambiguous name detected: GetNewInventory. Can you advise me what should I do? Thank you!

MieszkoKrychniak
Автор

The Toolbox Keeps disappearing and I have to shut down the entire file and restart to get it back making the form section of this impossible to complete. What am I doing wrong? It's not on another screen, I minimized everything else looking for it, and just touching anything else seems to make it disappear even though it still says it's active in the dropdown menu. Click that on and off does nothing. I'm frustrated to tears over this.

LaurenYork-Toenniges
Автор

I'm new to VBA and would like to take the time to to watch and learn but I have Excel 365. Would this still be the proper course despite having a different version of Excel?

j.n.
Автор

Great course! At 16:32, you can undo the last step by pressing ctrl C, I tried to do the same on my lenovo laptop, but it didn't work out, instead, it just copied a cell. What can I do?

donaldtze
Автор

Please make a video on powerpoint also

ak