First Step - Know your current level of Excel VBA
Introduction to Microsoft Excel Macro
-
How to Record your first macro (3:15)
-
Write your first macro (5:47)
-
Get Last Row (3:49)
-
Get Next Row (4:25)
-
Using ActiveCell object (4:01)
-
CurrentRegion and SpecialCell (5:00)
-
Copy worksheet (5:40)
-
Inserting blank row (6:51)
-
Bold Rows selected using Selection Object (5:34)
-
Using ActiveCell (1:56)
-
Calling other procedure (3:57)
-
Automate Subtotal (4:04)
-
Write code to combine words (7:06)
Mastering Flow Control
Repeating a set of instruction using Loop
User Interaction
Managing File and Folder
-
Using the DIR (2:50)
-
List all filename (3:30)
-
Part 1 - Save current worksheet as CSV File (3:22)
-
Part 2 - Recording the PowerQuery code (4:35)
-
Part 3 - Run PowerQuery then Save as csv file (4:21)
-
Move File and InStrRev to remove file extension (6:11)
-
Move All Excel file to another folder and Rename it (8:01)
-
Sort File in Folder and Open Last Modifed File in a Folder (2:59)
-
How to Loop Through all Sheets in all Files in a Folder (2:59)
Automate Pivot Table
Useful Macro Tool for Finance and Account Professional
Case Study - Splitting Master File to several Child Files using Macro and PowerQuery
Pivot Table Automation 2
Transferring Sales Datas to Master File
Work with other workbook
Work with Google Sheet
