0101 – Why learn Macros?
0102 – Activate the “Developer” tab
0103 – Saving a Macro-enabled WorkBook (XLSM)
0104 – Macro Security Settings
0105 – Developer tab – Essential Buttons
0106 – Head & Tail of a Macros (Sub Procedur & User Defined Function)

Download Course Curriculum

0201 – Macros – Record & Run
0202 – Macros – Viewing the code
0203 – Macro-free vs. Macro-enabled Workbook
0204 – Visual Basic Editor (VBE)
0205 – Personal Macro WB
0206 – Ways to Run a Macro

Download Course Curriculum

0301 – Using Google to locate useful VBA codes – 1
0302 – Using VBE and Macro Recorder to customize Macro code
0303 – Using Google to locate useful VBA codes – 2

Download Course Curriculum

0401 – Objects, Properties, Values, Methods, and Parameters 1
0402 – Objects, Properties, Values, Methods, and Parameters 2

Download Course Curriculum

0501 – Code Color & Activating Edit Toolbar w. Comments
0502 – Edit Toolbar – Indent, Bookmark 1.5
0503 – Code writing shortcuts incl. Intellisense
0504 – Testing the Code
0505 – Immediate Window

Download Course Curriculum

0601 – Range Selection – Method 1
0602 – Range Selection – Method 2 & 3
0603 – Advantage of Range Selection – Method 2 & 3
0604 – Range Selection (Rows & Columns) – Method 4
0605 – Assigning values to the selected range of cells
0606 – Exercise 1 – Assigning values to the selected range of cells
0607 – Exercise 2- Assigning values to the selected range of cells
0608 – Multiple Range Selection – Method 5
0609 – Multiple Range Selection – Method 6
0610 – Range Selection Ways – Others

Download Course Curriculum

0701 – Offset – Basics
0702 – Using Relative Reference in Macros

Download Course Curriculum

0801 – Navigating between a range of cells – Part 1
0802 – Navigating between a range of cells – Part 2
0803 – Navigating between a range of cells – Part 3
0804 – Exercise – Finding the Last Row No.
0805 – Exercise – Finding the Last Column No.
0806 – Exercise – Finding Next Row No.

Download Course Curriculum

0901 – Variable Decl – 1
0902 – Variable Decl – 2
0903 – Pvt vs Public – 1
0904 – Pvt vs Public – 2
0905 – Option Explicit
0906 – Difference – DIM vs. SET

Download Course Curriculum

1001 – “For…Next”
1002 – “If…Else…End If” nested within “For…Next”
1003 – “Do…While”
1004 – “Do…Until”
1005 – “For Each…Next”
1006 – “If…End If” nested within “For Each…Next”
1007 – Exercise – “Do While” and Loop Counter
1008 – “With…End With” – Example 1
1009 – “With…End With” – Example 2
1010 – “Select…Case” – Demonstration
1011 – “Select…Case” – Explanation

Download Course Curriculum

1101 – Speed up the code running – 1
1102 – Speed up the code running – 2
1103 – Speed up the code running – 3

Download Course Curriculum

1201 – Introduction
1202 – Events – Workbook Open and Worksheet Activate
1203 – Exercise 1 – Tracking Workbook Opens
1204 – Exercise 2 – Tracking Workbook Save
1205 – Event – Worksheet Before Double Click
1206 – Event – Worksheet Change
1207 – Event – Worksheet Calculate
1208 – Pivot Table – Refresh – Work Sheet Activate

Download Course Curriculum

1301 – Introduction
1302 – Input Box – 1
1303 – Input Box – 2
1304 – Input Box – 3
1305 – Input Box – 4

Download Course Curriculum

1401 – Introduction to Msg box in Excel VBA
1402 – MsgBox – 1
1403 – MsgBox – 2
1404 – MsgBox – 3
1405 – MsgBox – 4

Download Course Curriculum

1501 – Form Controls vs ActiveX Controls
1502 – MouseMove Event w. Appln Statusbar

Download Course Curriculum

1601 – Introduction 1.0
1602 – User Form – Basics
1603 – Exercise – Part 1 of 4
1604 – Exercise – Part 2 of 4
1605 – Exercise – Part 3 of 4
1606 – Exercise – Part 4 of 4
1607 – Option Button – 1
1608 – Option Button – 2
1609 – Multi Page – Introduction
1610 – Multi Page – 1
1611 – Multi Page – 2
1612 – Multi Page – 3
1613 – Check Box
1614 – Combo Box – Method 1
1615 – Combo Box – Method 2

Download Course Curriculum

1701 – UDF Introduction
1702 – UDF Example 1 – ScoreResult with IF END IF
1703 – UDF Example 2 – CellComments
1704 – UDF Samples – Series A
1705 – UDF Samples – Series B

Download Course Curriculum

1801 – Split Workbook
1802 – Protect – Unprotect Sheets
1803 – Index of Hyperlinks to all Sheets
1804 – Extract all Comments of a WorkBook to a new WorkSheet
1805 – Project- Automate, Comment, Insertion, and Extraction
1806 – Count Cells by Color
1807 – Combine WorkSheets

Download Course Curriculum

1901 – Case Study- Intro
1902 – Case Study – Demo
1903 – Create the first UserForm
1904 – Write the first line of code
1905 – VBA code to match Username and Password
1906 – Continue with UserForm
1907 – VBA code for the second UserForm
1908 – Unload and Hide UserForm
1909 – Setting of the third UserForm
1910 – Validation for the third UserForm – Part 1
1911 – VBA code to enable a button
1912 – Validation for the third UserForm – Part 2
1913 – VBA code for the third UserForm
1914 – Configuring the Previous button
1915 – Submit Data and hide content in excel sheet
1916 – Capture data from the UserForm
1917 – Create a Table Format
1918 – VBA code to send Email
1919 – Send an Email
1920 – The finishing touch to the project
1921 – Testing the code

Download Course Curriculum