Automate Subtotal | AmazingExcel

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Excel VBA/MACRO

First Step - Know your current level of Excel VBA

Know yourself (6:50)

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

Basic of IF (3:28)
If Else If (4:55)

Repeating a set of instruction using Loop

Basic of For Loop (4:44)
Generate list of Report using For Loop (5:38)
Terminating a Loop (2:26)
For Each Loop (5:34)
Delete Row using AutoFilter (4:44)
Delete Row using For Loop (7:56)
Using OnError Statement (4:32)

User Interaction

MsgBox (3:09)
MsgBox Yes No (4:57)
User Form (3:49)

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

Refresh Multiple Pivot Table Fast (7:25)
Copy Pivot Table Label fast (7:15)

Useful Macro Tool for Finance and Account Professional

A Macro magic to turn Number to Word (3:40)
Copy Filtered data to a New Workbook according to a List of country code (8:15)

Case Study - Splitting Master File to several Child Files using Macro and PowerQuery

Introduction to the challenge (3:53)
Step 1 - Recording Powerquery step using Macro (4:53)
Step 2 - Modify recorded code and powerquery M code (7:06)
Step 3 - Copy query report to New Workbook (5:20)

Pivot Table Automation 2

Generate Like 'Report Filter Page' in Pivot Table Part 1 (7:26)
Generate Like 'Report Filter Page' in Pivot Table Part 2 (4:25)
Pivot Table - get first column frist row Total Column Total Row (11:55)

Transferring Sales Datas to Master File

Excel VBA - Merge many Sales Data into Master file Part 1 (2:41)
Excel VBA - Merge many Sales Data into Master file Part 2 (3:00)
Excel VBA - Merge many Sales Data into Master file Part 3 (5:42)

LEVEL 3

Rescuing A Manufacturing Business Analyst IMPOSSIBLE task to POSSIBLE (15:58)

Event Handling

How to detect if user select a worksheet
Display a message when user open a workbook

Work with other workbook

Open and close workbook (6:31)
Open Workbook Close Workbook Using Find (6:31)

Work with Google Sheet

The concept - Demo (5:53)

Teach online with

Automate Subtotal

Download

Automate Subtotal with Macro.xlsm

Download

Subtotal_MonthlySales.xlsx

Complete and Continue