Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Macros for Beginners [Premium]
Course Description and Requirements
Course Description and Requirements
Welcome! Please Start Here
Lesson 1: How to Use the Course Software (8:00)
Lesson 2: Main Purpose of Excel Macros for Beginners (6:36)
Lesson 3: The VBA Project You Develop (8:20)
Lesson 4: Course Structure (17:52)
Module 1: Introduction to Macros and VBA
Lesson 1: What are Macros and VBA (8:49)
Lesson 2: Why Learn and Use Macros and VBA (18:16)
Lesson 3: Considerations when Working with VBA (9:00)
Lesson 4: How to Approach Learning Macros and VBA (12:58)
Module 2: Set Up Excel to Work with Macros
Lesson: Set Up Excel to Work with Macros (4:09)
Module 3: Macro Security
Lesson 1: Introduction to Macro Security (6:11)
Lesson 2: Enable or Disable Macros (7:40)
Bonus Lesson 3: Trusted Locations and Publishers (4:48)
Lesson 4: Save Workbooks with Macros (6:39)
Module 4: Record Macros
Lesson 1: Introduction to the Macro Recorder (5:45)
Lesson 2: Absolute and Relative References (13:26)
Lesson 3: Record a Macro (7:41)
Exercise Lesson 3: Record a Macro (3:06)
Bonus Lesson 4: The Personal Macro Workbook (3:25)
Lesson 5: When to Use the Macro Recorder (18:18)
Module 5: Execute Macros
Lesson 1: Introduction to Macro Execution (6:25)
Lesson 2: Execute Macros with Keyboard Shortcuts (10:14)
Exercise Lesson 2: Execute Macros with Keyboard Shortcuts (4:05)
Lesson 3: Execute Macros by Clicking on Buttons or Other Elements (9:47)
Bonus Lesson 4: Execute Macros from the Quick Access Toolbar or the Ribbon (8:14)
Lesson 5: Execute Macros from the Macro Dialog Box (2:58)
Module 6: Delete Macros
Lesson: Delete Macros (2:02)
Module 7: The Visual Basic Editor
Lesson 1: Introduction to the Visual Basic Editor (9:29)
Lesson 2: Open the VBE (2:53)
Lesson 3: The Project Explorer (6:56)
Lesson 4: Work with Modules (9:41)
Lesson 5: The Code Window (11:10)
Bonus Lesson 6: Introduction to Customizing the VBE and Customizing VBE Windows (11:31)
Module 8: Work with VBA
Lesson 1: Introduction to the Basic Elements of VBA (9:13)
Lesson 2: The Basic Structure of a VBA Statement (5:19)
Exercise Lesson 2: The Basic Structure of a VBA Statement (21:37)
Lesson 3: The With... End With Statement (8:34)
Exercise Lesson 3: The With... End With Statement (3:03)
Bonus Lesson 4: How the Macro Recorder Translates Your Actions to VBA (5:31)
Bonus Exercise Lesson 4: How the Macro Recorder Translates Your Actions to VBA (3:19)
Bonus Lesson 5: Step Through Code (7:53)
Lesson 6: Delete Macros or Edit VBA Code (9:25)
Exercise Lesson 6: Delete Macros or Edit VBA Code (14:43)
Lesson 7: How the Macro Recorder Refers to Cell Ranges (15:06)
Exercise Lesson 7: How the Macro Recorder Refers to Cell Ranges (21:44)
Module 9: Code Formatting, Organization and Review
Lesson 1: Introduction to Editor Tab Settings and Auto Syntax Check (8:52)
Bonus Lesson 2: Editor Format Settings (6:15)
Lesson 3: Code Formatting and Organization Practices (10:09)
Lesson 4: Comments (9:21)
Module 10: Tools for Creating Macros from Scratch
Lesson 1: Introduction to Tools for Creating Macros from Scratch (3:44)
Lesson 2: Revisiting the Macro Recorder (4:52)
Lesson 3: VBA's Help System, Microsoft Developer Network and Office Dev Center (13:41)
Bonus Lesson 4: The Object Browser (11:29)
Bonus Lesson 5: Auto List Members, Complete Word and Auto Quick Info (10:45)
Bonus Lesson 6: The Immediate Window (10:03)
Lesson 7: Use VBA Code from Experts (9:20)
Module 11: Complete Your VBA Project
Lesson 1: Make Macros Work Together (5:05)
Lesson 2: Structure Your VBA Project (12:40)
Exercise Lesson 2: Structure Your VBA Project (20:23)
Course Wrap-Up
Lesson 1: Course Wrap-Up (9:35)
Lesson 2: What's Next (7:14)
Lesson 3: VBA's Help System, Microsoft Developer Network and Office Dev Center
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock