All Levels
16 hours
Java Tutorial for Complete Beginners
Learn to program using the Java programming language
John Purcell
What you'll learn:
- ✓Learn to program in Java
16 hours
73 lectures
Access on mobile and TV
Certificate
DevelopmentJava
All LevelsOffice ProductivityExcel VBA
Excel VBA Programming - The Complete Guide
Automate your Microsoft Excel workflow, accelerate your productivity, and master programming with VBA! Beginners welcome
Created by Boris Paskhaver
18 hours
Video Content
159
Lectures
74,468
Students
4.6
Rating
4.6
(74,468 students enrolled)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
Course Content
18 sections • 159 lectures • 17:58:12 total length
Getting Started
10 lectures • 01:15:14
Getting Started
10 lectures • 01:15:14
Introduction13:08
About Me00:56
Download Course Materials00:42
Enable the Developer Tab07:06
Excel File Types04:00
+7 more lectures
The Fundamentals of the Excel Object Model
7 lectures • 51:39
The Fundamentals of the Excel Object Model
7 lectures • 51:39
Object-Oriented Programming in Real Life11:29
Real Life Objects3 questions
Collection Objects in Real Life05:50
Objects As Properties09:08
The Excel Object Model13:34
+4 more lectures
The Visual Basic Editor
5 lectures • 50:07
The Visual Basic Editor
5 lectures • 50:07
Visual Basic Editor Options13:39
Create and Delete a Procedure08:51
Procedures5 questions
The Immediate Window and Debug.Print Method08:45
The MsgBox Method13:34
+3 more lectures
Objects and Methods
6 lectures • 38:18
Objects and Methods
6 lectures • 38:18
Methods without Arguments03:28
Methods without Arguments3 questions
Methods with Arguments08:30
Methods with Arguments3 questions
Methods with Multiple Arguments06:42
+4 more lectures
Variables and Data Types
13 lectures • 01:20:06
Variables and Data Types
13 lectures • 01:20:06
Syntax Tips07:37
Variable Declarations and Assignments10:01
Multiple Variable Declarations04:14
The Option Explicit Setting05:52
The Byte, Integer and Long Data Types07:54
+11 more lectures
Procedures
7 lectures • 47:10
Procedures
7 lectures • 47:10
Variable Scope09:30
Call A Procedure from Another one03:54
Procedures with Arguments07:15
Procedure Scope (Public vs. Private)06:54
The Exit Sub Keywords01:49
+3 more lectures
Object Deep Dive
14 lectures • 01:07:45
Object Deep Dive
14 lectures • 01:07:45
The Application Object04:14
The Application.DisplayAlerts Property06:26
The Workbooks.Count and Worksheets.Count Properties02:07
The Workbooks.Open Method and Workbook.Path Property06:59
The Workbooks.Close Method01:47
+11 more lectures
Range References
15 lectures • 01:26:13
Range References
15 lectures • 01:26:13
The Range.Select Method08:42
The Value vs. Text Properties03:50
R1C1 Notation, Part I09:53
R1C1 Notation, Part II07:55
The Formula and FormulaR1C1 Properties06:47
+11 more lectures
Range Actions
14 lectures • 01:22:19
Range Actions
14 lectures • 01:22:19
The Range.FillDown Method05:01
The Range.Replace Method04:42
The Range.TextToColumns Method09:28
The Range.Worksheet Property02:09
The Range.Sort Method12:32
+9 more lectures
Conditionals
6 lectures • 45:55
Conditionals
6 lectures • 45:55
Boolean Expressions06:27
Boolean Expressions9 questions
The If Then Statement04:05
The ElseIf and Else Statements10:41
Select Case10:41
+3 more lectures
Iteration
7 lectures • 01:06:28
Iteration
7 lectures • 01:06:28
The For Next Loop13:51
The Step Keyword07:09
Deleting Rows10:50
Fill Empty Rows1 question
The For Each-Next Construct07:49
+4 more lectures
Miscellaneous Features
8 lectures • 49:43
Miscellaneous Features
8 lectures • 49:43
The MsgBox Method In Depth, Part I08:03
The MsgBox Method In Depth, Part II06:58
MsgBox Options00:28
StatusBar06:00
The Application.ScreenUpdating Property04:18
+3 more lectures
Arrays
7 lectures • 41:48
Arrays
7 lectures • 41:48
Intro to Arrays06:27
Alternate Syntax for Fixed-Size Arrays04:49
The Option Base 1 Syntax and Write Array Values to Cells04:24
Initialize Arrays within a For Loop05:58
The LBound and UBound Methods06:12
+2 more lectures
Functions
8 lectures • 01:00:24
Functions
8 lectures • 01:00:24
VBA Functions, Part I09:31
VBA Functions, Part II06:48
The Split Function04:23
The Is Family of Functions09:55
Date and Time Functions04:37
+3 more lectures
Debugging
6 lectures • 42:25
Debugging
6 lectures • 42:25
Intro to Error Handling07:19
The OnError and GoTo Keywords07:06
The OnError Resume Next Keywords05:28
Error and Err.Number08:03
Stepping Through Code08:24
+1 more lectures
Events
8 lectures • 46:59
Events
8 lectures • 46:59
Introduction to Events06:56
The Worksheet_SelectionChange Event06:20
Review of Application.EnableEvents03:27
The Worksheet_Change Event12:28
The Worksheet_Activate Event02:47
+4 more lectures
User Forms
17 lectures • 01:48:35
User Forms
17 lectures • 01:48:35
Create UserForm, Toolbox, Properties, Controls07:00
The Label and TextBox Controls04:46
Naming Conventions03:14
Naming Conventions00:08
Design Aesthetics06:14
+12 more lectures
Conclusion
1 lectures • 00:21
Conclusion
1 lectures • 00:21
Bonus00:21
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
This course includes:
- 18 hours on-demand video
- 4 articles
- 1 downloadable resources
- Access on mobile and TV
- ∞Full lifetime access
- Certificate of completion
Instructor
Boris Paskhaver
Students also download
Explore related courses to expand your learning journey.
All Levels
22 hours
The Complete Python Bootcamp From Zero to Hero in Python
Learn Python like a Professional Start from the basics and go all the way to creating your own applications and games
Jose Portilla
What you'll learn:
- ✓You will learn how to leverage the power of Python to solve tasks.
- ✓You will build games and programs that use Python libraries.
- ✓You will be able to use Python for your own work problems or personal projects.
- +9 more skills
22 hours
156 lectures
Access on mobile and TV
Certificate
DevelopmentPython
All Levels
52 hours
100 Days of Code: The Complete Python Pro Bootcamp
Master Python by building 100 projects in 100 days. Learn data science, automation, build websites, games and apps!
Dr. Angela Yu, Developer and Lead Instructor
What you'll learn:
- ✓You will master the Python programming language by building 100 unique projects over 100 days.
- ✓You will learn automation, game, app and web development, data science and machine learning all using Python.
- ✓You will be able to program in Python professionally
- +6 more skills
56.5 hours
592 lectures
Access on mobile and TV
Certificate
DevelopmentPython