Part 1
-
Applying SUMIF (2:21)
-
Applying SUMIFS (7:01)
-
COUNTIF and Excel Table (5:00)
-
COUNTIF - How to count if a value is less than certain number (2:50)
-
Amazing Excel Advanced Function - COUNTIF with Wild Card (5:08)
-
Conditional Formatting - Format according to your business requirement or certain Text value (3:09)
-
Advanced Conditional Formatting - Example 1 (3:11)
-
Advanced Conditional Formatting - Highlight Positive Change (4:27)
-
Interesting Case Study - Find duplicate value in another sheet (3:15)
-
Case Study - identify Product code if Last letter is G (3:51)
-
Case Study - Identify which membership expired using Conditional Formatting (4:38)
Part 2
-
Creating Your First Pivot Table (4:13)
-
Pivot Table - Create Multiple Column (Sales Total and Num of Trans) (5:58)
-
Create Pivot Chart (3:35)
-
Create Calculated Field (3:11)
-
Discovering the power of Grouping feature in Pivot Table (7:51)
-
Show Value As - % Different From and Difference From (4:41)
-
Show Value As - Column Total vs Row Total (2:23)
-
Show Value As % of Row Total and % of Column Total (3:36)
-
Show Value As - Percent of Column Total and Percent of Parent Row Total
-
Show Value As - Running Total (2:47)
-
Calculated Field Variance with arrow Up Down (5:24)
-
Pivot Table - Custom List - Create a list according to your own order Save Time (7:25)
Part 3
-
Excel Advanced Function - INDEX (4:09)
-
Advanced Function - leverage the strength of MATCH and INDEX (2:42)
-
INDEX and MATCH - Part 2 (8:36)
-
How to find the lowest supplier price Part 1 (3:42)
-
How to find the lowest supplier price Part 2 (5:05)
-
Excel Advanced Function - Variance Analysis using OFFSET and MATCH (4:09)
-
Date Related Excel Function (1:35)
-
Date Related Function - NETWORKDAY (3:35)
-
Nested IF (2:49)
-
Nested IF - Part 2 (2:50)
-
Excel Macro/VBA - Recording Your first Macro (5:56)
-
How to Save Your Workbook with Macro code (5:41)
-
Case Study - Generate Salary Slip, Invoice faster than you think using Macro (7:27)
-
Case Study - Generate Salary Slip, Invoice faster than you think using Macro Part 2 (6:55)
-
Search a Color in a list using SEARCH ISNUMBER XLookup (5:12)
Part 4
-
Data Table - Example 1 (4:30)
-
Data Table - Example 2 (6:30)
-
Data Table - Two Input Variables (6:42)
-
Goal Seek (4:15)
-
Using Wild Card in filtering data (4:54)
-
Named Range (6:39)
-
Case Study - Find out Gender based on Identification Number IC using Excel RIGHT function (4:13)
-
Capture certain part of Maybank Bank Statement using PowerQuery
-
Powerquery - How to fill down details fast (4:33)
-
How to say goodbye to VLookup (8:58)
