Section 01: Introduction | |||
Recording Macros vs Writing VBA | 00:04:00 | ||
Understanding Objects in Excel VBA | 00:07:00 | ||
Understanding VBA Syntax and Parts of Speech | 00:10:00 | ||
Activating the Developer tab | 00:01:00 | ||
Recording a basic Macro | 00:05:00 | ||
Absolute vs Relative Macro recording | 00:04:00 | ||
Section 02: Exploring the Visual Basic Environment | |||
Introduction to the Visual Basic Environment | 00:02:00 | ||
The Project Explorer | 00:02:00 | ||
The Properties Window | 00:02:00 | ||
The Code Window | 00:04:00 | ||
Immediate, Locals and Watch Window | 00:03:00 | ||
Dealing with Modules | 00:03:00 | ||
Comments in Excel VBA | 00:01:00 | ||
Section 03: The Range Object | |||
Introduction and Changing Cell Values | 00:10:00 | ||
Adding a text to a cell | 00:01:00 | ||
Dealing with Named Ranges | 00:03:00 | ||
Value vs Text Property | 00:04:00 | ||
Row and Column properties | 00:02:00 | ||
The Select Method | 00:02:00 | ||
The Count Property | 00:04:00 | ||
The Address Property | 00:09:00 | ||
The Formula Property | 00:03:00 | ||
The Number Format Property | 00:07:00 | ||
The Font Property | 00:08:00 | ||
Section 04: Understanding the Cells Collection Object | |||
What is the cells object? | 00:06:00 | ||
Using the Cells collection to affect cells positionally within a range | 00:05:00 | ||
Affecting all cells within a sheet | 00:02:00 | ||
Combining Range and cells objects | 00:03:00 | ||
Section 05: Working with Sheets/Worksheets | |||
Selecting Sheets | 00:06:00 | ||
Adding Sheets | 00:11:00 | ||
Sheets vs Worksheets | 00:04:00 | ||
Copying Sheets | 00:05:00 | ||
Moving Sheets | 00:01:00 | ||
Deleting Sheets | 00:04:00 | ||
Section 06: Understanding Variables in Excel VBA | |||
Introduction to Variables | 00:06:00 | ||
Variable Data Types | 00:09:00 | ||
Declaring Variables | 00:14:00 | ||
Object Variables | 00:08:00 | ||
Calling a procedure from Another Procedure & Variable Scope | 00:03:00 | ||
Public and Private Variables | 00:07:00 | ||
Declaring Constants | 00:04:00 | ||
Exercises-Variables | 00:06:00 | ||
Section 07: Dealing with Workbooks | |||
Referring to Workbooks-Different ways | 00:04:00 | ||
Closing Workbooks | 00:03:00 | ||
Adding and Saving Workbooks Part 1 – Save method | 00:04:00 | ||
Adding and Saving Workbooks Part 2 – Save as method | 00:10:00 | ||
Opening Workbooks | 00:06:00 | ||
Section 08: Must Know Excel VBA Logic | |||
Finding the Last row | 00:09:00 | ||
Finding the Last Column | 00:04:00 | ||
Finding the next row | 00:04:00 | ||
The WITH Statement | 00:04:00 | ||
Comparison operators in Excel VBA | 00:01:00 | ||
IF Statements- Simple IF Statements | 00:07:00 | ||
IF THEN ELSE Structure | 00:03:00 | ||
IF THEN ELSEIF Structure | 00:07:00 | ||
Nested IFs | 00:04:00 | ||
OR – AND logical operators | 00:07:00 | ||
NOT Logical operator | 00:03:00 | ||
CASE Statements Part 1 – Single Case Statements | 00:09:00 | ||
CASE Statements Part 2 – Nested Case Statements | 00:06:00 | ||
Case Statements-Exercise | 00:01:00 | ||
GOTO and Labels | 00:03:00 | ||
Section 09: Looping in Excel VBA | |||
Loops-Introduction | 00:01:00 | ||
FOR NEXT Loop | 00:11:00 | ||
Exit For | 00:09:00 | ||
Exercise – For Next loop | 00:01:00 | ||
FOR EACH Loop – Intro | 00:07:00 | ||
FOR EACH Loops – More examples | 00:05:00 | ||
Do Loop – Introduction | 00:04:00 | ||
Do Loop Example | 00:01:00 | ||
Do Until | 00:02:00 | ||
Do While | 00:02:00 | ||
Do while vs Do until – Movies Example | 00:04:00 | ||
Exit Do Statement | 00:05:00 | ||
Exercise – Do Loop | 00:01:00 | ||
Section 10: Interacting with Your Users | |||
The Messagebox – Introduction | 00:03:00 | ||
Messagebox -Inputs | 00:07:00 | ||
Messagebox – Capturing the User’s input | 00:05:00 | ||
Adding a new line to your VBA Strings | 00:02:00 | ||
The Inputbox – introduction | 00:04:00 | ||
Inputbox – Example1 – Capturing a user’s name | 00:05:00 | ||
Inputbox -Employee Database Example Part 1 | 00:05:00 | ||
Inputbox -Employee Database Example Part 2 | 00:04:00 | ||
Exercise – InputBox | 00:02:00 | ||
Section 11: Error Handling in Excel VBA | |||
Error Handling – Introduction | 00:09:00 | ||
Different Error types in action | 00:04:00 | ||
On Error Goto statement | 00:04:00 | ||
Resetting the error handling Status with On Error Goto | 00:02:00 | ||
The Err Object | 00:07:00 | ||
Setting a Breakpoint | 00:02:00 | ||
Section 12: Triggering Code with Events! | |||
Worksheet Events -Selection change | 00:08:00 | ||
Worksheet Events – Worksheet Activate event | 00:03:00 | ||
Worksheet Events – Deactivate event | 00:02:00 | ||
Worksheet Events – Before Delete Event | 00:02:00 | ||
Worksheet Events – Before Double click event | 00:08:00 | ||
Worksheet Events – Before Right Click event | 00:03:00 | ||
Worksheet Events – Calculate event | 00:03:00 | ||
Enabling and Disabling Events | 00:03:00 | ||
Worksheet events – Worksheet change event | 00:11:00 | ||
Worksheet events – Follow Hyperlink event | 00:03:00 | ||
Worksheet events -Exercise | 00:01:00 | ||
Workbook Events – Workbook open event | 00:05:00 | ||
Workbook Events – Workbook Activate event | 00:02:00 | ||
Workbook Events – Workbook Before save event | 00:06:00 | ||
Workbook Events – Workbook Aftersave event | 00:04:00 | ||
Workbook Events – Workbook Beforeclose event | 00:09:00 | ||
Workbook Events – Workbook BeforePrint event | 00:03:00 | ||
Workbook Events -Workbook De-activate events | 00:02:00 | ||
Workbook Events – New Chart event | 00:08:00 | ||
Workbook Events -New sheet event | 00:03:00 | ||
Workbook Events – Sheet calculate event | 00:03:00 | ||
Workbook Events – Sheet De-activate event | 00:06:00 | ||
Workbook Events – Follow Hyperlink event | 00:02:00 | ||
Workbook Events – Workbook Window Activate event | 00:06:00 | ||
Workbook Events – Workbook Window De-Activate event | 00:02:00 | ||
Workbook Events – Window Resize event | 00:02:00 | ||
Exercise- Workbook Events | 00:01:00 | ||
Resources | |||
Resources – Excel VBA/Macros Foundations | 00:00:00 | ||
Assignment | |||
Assignment – Excel VBA/Macros Foundations | 2 weeks, 1 day | ||
Order Your Certificate | |||
Order Your Certificate QLS | 00:00:00 |
Scholarship: Score 80% or more in your final exam to get this Fee refunded.
Membership renews after 12 months. You can cancel anytime from your account.