This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Advanced Level Course
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)
How to find the lowest supplier price Part 1
Download
04 Find the Lowest 2.xlsx
Complete and Continue