Preview Excel VBA Mastery Program

Back

Course Tracker

Excel VBA Mastery Program Tracker

Section 01 - Introduction

Why do we learn Excel VBA Macros?

How to learn Excel VBA Macros?

Section 02 - Basic Settings

How to enable Developer Tab in Excel?

Basics of Developer Tab in Excel

Important Macro Security Settings in Excel

How to save Macros in Excel for future use?

Section 03 - Record & Run Macros

How to create a Macros in Excel

How to run a Macro in all open Workbooks

Using a Button to run a Macros in Excel

Running a Macro in different ways in Excel

Understanding VBA Workspace in Excel (Basics)

Watch a Macro being recorded

Section 04 - Google Readymade VBA Codes

Searching Google for VBA Codes - using the 3 magic words

Searching Google for VBA Codes - in Blogs vs Forum

Section 05 - Know Your Workspace

VBA Workspace - a detailed tour

How to increase the font size of the VBA Codes

3 shortcuts to write VBA Codes faster

VBA Code Testing Tricks

Section 06 - Objects, Properties, Methods

Concept of Objects, Properties, Methods in Excel VBA - Part 1

Concept of Objects, Properties, Methods in Excel VBA - Part 2

Concept of Objects, Properties, Methods in Excel VBA - Part 3

Concept of Objects, Properties, Methods in Excel VBA - Part 4

Section 07 - Range & Cells Object

Range and Cells Object in Excel VBA

Example - Using Cells Object with a simple Do-While Loop

What is OFFSET property in Excel VBA

Section 08 - Range Navigation

Range Navigation in Excel VBA (Basics)

Exercise - Finding Last filled Row and Next Row in Excel VBA

Exercise - Finding Last Column No. (English)

Section 09 - Variable Declaration

Variables - Concept, How and Why declare Variables, Initialization

Variables - Data Types

Variables - Best Practices to name Variable

Variables - How to remember to declare Variables (Option Explicit)

Variables - DIM vs SET

Pvt vs Public - Part 1 (English)

Pvt vs Public - Part 2 (English)

Section 10 - Loops

Loops - For Next Loop - Basics

Loops - If Then Else with For Next Loop

Loops - For Each Next - Basics

Loops - If Then Else with For Each Next Loop

Loops - Do While Loop - Basics

Loops - Do Until Loop - Basics

Loops - With Statement

Loops - Select Case - Basics

Section 11 - Input Box & Message Box

Input Box - Basics

Input Box - Inserting user input in a cell

Input Box - Different Value Types

Input Box with IF Then Else Statement

MsgBox Introduction (English)

MsgBox - Part 1 (English)

MsgBox - Part 2 (English)

MsgBox - Part 3 (English)

MsgBox - Part 4 (English)

Section 12 - User Forms

Project 1: Text Box and Command Button - Basics

Project 1: Text Box and Command Button - Designing

Project 1: Text Box and Command Button - Configuring

Project 1: Text Box and Command Button - Load button

Project 2: Option Button and Command Button - Basics

Project 2: Option Button and Command Button - Configuring

Project 3: Option Button in Multiple Clusters (3 ways) - Part 1

Project 3: Option Button in Multiple Clusters (3 ways) - Part 2

Multi Page - Introduction (English)

Multi Page - Part 1 (English)

Multi Page - Part 2 (English)

Multi Page - Part 3 (English)

Check Box - Part 1 (English)

Combo Box - Method 1 (English)

Combo Box - Method 2 (English)

Section 13 - User Defined Functions (UDF)

Basics of User Defind Functions (UDF)

UDF Example 1 – Score Result with IF END IF (English)

UDF Example 2 – Cell Comments (English)

UDF Samples – Series A (English)

UDF Samples – Series B (English)

Section 14 - ActiveX Controls

Form Controls vs ActiveX Controls (English)

MouseMove Event w. Appln Statusbar (English)

Section 15 - Events

Introduction of Events (English)

Events – Workbook_Open and Worksheet_Activate (English)

Exercise 1 – Tracking Workbook Opens (English)

Exercise 2 – Tracking Workbook Save (English)

Event – Worksheet_BeforeDoubleClick (English)

Event – Worksheet_Change (English)

Event – Worksheet_Calculate

Pivot Table – Refresh – WorkSheetActivate (English)

Section 16 - Excel VBA Projects

Excel VBA for Non-Coders Project 1

F&R Text CHR

Preview - Excel VBA Mastery Program