Excel Macros and VBA for Beginner Users

Thumbnail image
Course Introduction
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:14
Thumbnail image
What is VBA
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:52
Thumbnail image
What VBA is Not
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 1:16
Thumbnail image
Essential VBA Terminology
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:02
Thumbnail image
What is a Macro AKA Sub Procedure
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:08
Thumbnail image
How are Macros Created
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:16
Thumbnail image
Where is VBA Coding Done
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 1:18
Thumbnail image
Where are Macros Stored
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 1:41
Thumbnail image
Macro Enabled Workbooks
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:50
Thumbnail image
Accessing Macros
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:57
Thumbnail image
The Personal XLSB Workbook
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:10
Thumbnail image
Not All Macros are Good
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 1:48
Thumbnail image
Macro Security Settings
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:10
Thumbnail image
Setting Up a Trusted Location
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:12
Thumbnail image
Review
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:58
Thumbnail image
Introduction Creating Macro
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 0:59
Thumbnail image
Displaying the Developer Tab
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:08
Thumbnail image
Saving as a Macro Enabled Workbook
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:16
Thumbnail image
Launching Visual Basic Editor
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:52
Thumbnail image
Setting Up the VBE Interface
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 5:17
Thumbnail image
Explorer Window Part 1
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:32
Thumbnail image
Explorer Window Part 2
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:24
Thumbnail image
Inserting a Module
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:24
Thumbnail image
Renaming and Deleting a Module
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:00
Thumbnail image
Basic Syntax to Start and End a Macro
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:46
Thumbnail image
Naming the Macro
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 1:37
Thumbnail image
Declaring the Start and End of a Macro
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:20
Thumbnail image
Writing the Instructions Part 1
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 1:53
Thumbnail image
Writing the Instructions Part 2
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:45
Thumbnail image
Writing the Instructions Part 3
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:14
Thumbnail image
Automatic Formatting
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:04
Thumbnail image
Line Continuation Character
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:08
Thumbnail image
Inserting Comments
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 4:52
Thumbnail image
Convert Multiple Lines Into Comments
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 1:50
Thumbnail image
Inserting Blank Lines
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 1:31
Thumbnail image
Auto Syntax Check
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:37
Thumbnail image
Review of Formatting
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:01
Thumbnail image
Running a Macro
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:32
Thumbnail image
Before You Run a Macro
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:02
Thumbnail image
Run Sub User Form
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 4:38
Thumbnail image
Macros List Part 1
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:44
Thumbnail image
Macros List Part 2
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:56
Thumbnail image
Keyboard Shortcut
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:05
Thumbnail image
Command Button
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:22
Thumbnail image
Graphical Object or Button Control
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:11
Thumbnail image
Compile Error
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:50
Thumbnail image
Run Time Error
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:30
Thumbnail image
Recorder Introduction
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:01
Thumbnail image
Practice Run Through
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:57
Thumbnail image
Absolute VS Relative Mode
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:32
Thumbnail image
Recording
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 4:45
Thumbnail image
Running the Macro
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:01
Thumbnail image
Viewing the VBA Code
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:07
Thumbnail image
Editing the VBA Code
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:32
Thumbnail image
Deleting a Macro
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:04
Thumbnail image
A Common Mistake Part 1
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:18
Thumbnail image
A Common Mistake Part 2
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:03
Thumbnail image
A Common Mistake Part 3
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:10
Thumbnail image
A Common Mistake Part 4
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:37
Thumbnail image
Viewing VBA Statements Generated in Real Time
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:01
Thumbnail image
Selecting a Range of Any Size
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 4:19
Thumbnail image
Creating a Macro That Formats a Range of Any Size
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 4:13
Thumbnail image
Using CTRL A in Relative Mode
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 4:05
Thumbnail image
Using CTRL A in Absolute Mode
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:50
Thumbnail image
Navigating to the End of a Range of Any Size
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:13
Thumbnail image
Inserting Sum at the End of a Column of Any Size
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 6:19
Thumbnail image
Another Way to Navigate to the End of a Column of Any Size
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:41
Thumbnail image
When Does a New Module Get Created
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:49
Thumbnail image
Personal XLSB Workbook Generating the Personal XLSB Workbook
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 4:06
Thumbnail image
Storing a Macro
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:32
Thumbnail image
Unhiding or Hiding
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:20
Thumbnail image
Deleting the Personal XLSB Workbook
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:19
Thumbnail image
Using the Macro Recorder A Super Helpful Tip
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:27
Thumbnail image
Using Autosum
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:27
Thumbnail image
Autosum in Absolute Referencing Mode Part 1
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:19
Thumbnail image
Autosum in Absolute Referencing Mode Part 2
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:50
Thumbnail image
Autosum in Relative Referencing Mode
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 5:33
Thumbnail image
The Verdict on Using Autosum
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:08
Thumbnail image
Creating a Macro That Imports Data Part 1
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:56
Thumbnail image
Creating a Macro That Imports Data Part 2
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 4:41
Thumbnail image
Creating a Macro That Imports Data Part 3
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 5:52
Thumbnail image
Creating a Macro That Imports Data Part 4
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:19
Thumbnail image
Creating a Macro That Imports Data Part 5
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:17
Thumbnail image
Recorder Review
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:24
Thumbnail image
Creating a Macro for Debugging Purposes
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 4:42
Thumbnail image
Debugging a Macro Testing the Macro
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 5:57
Thumbnail image
Stepping Into the VBA Code
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 5:57
Thumbnail image
What is a Breakpoint
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 4:16
Thumbnail image
Inserting and Removing Breakpoints
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 4:16
Thumbnail image
Using Step Into and Breakpoints
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 4:23
Thumbnail image
Using Run to Cursor
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:26
Thumbnail image
What is Compiling
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 2:35
Thumbnail image
VBA Project Command
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 3:44
Thumbnail image
Changing the Editor Format Options
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 4:21
Thumbnail image
Final Words
Channel: Microsoft Excel Macros and VBA
Instructor: Lana
Duration: 1:32