Your Instructor
Course Curriculum
Part 1
Available in
days
days
after you enroll
-
PreviewApplying SUMIF (2:21)
-
StartApplying SUMIFS (7:01)
-
PreviewCOUNTIF and Excel Table (5:00)
-
StartCOUNTIF - How to count if a value is less than certain number (2:50)
-
StartAmazing Excel Advanced Function - COUNTIF with Wild Card (5:08)
-
StartConditional Formatting - Format according to your business requirement or certain Text value (3:09)
-
StartAdvanced Conditional Formatting - Example 1 (3:11)
-
StartAdvanced Conditional Formatting - Highlight Positive Change (4:27)
-
StartInteresting Case Study - Find duplicate value in another sheet (3:15)
-
StartCase Study - identify Product code if Last letter is G (3:51)
-
StartCase Study - Identify which membership expired using Conditional Formatting (4:38)
Part 2
Available in
days
days
after you enroll
-
PreviewCreating Your First Pivot Table (4:13)
-
StartPivot Table - Create Multiple Column (Sales Total and Num of Trans) (5:58)
-
StartCreate Pivot Chart (3:35)
-
StartCreate Calculated Field (3:11)
-
StartDiscovering the power of Grouping feature in Pivot Table (7:51)
-
StartShow Value As - % Different From and Difference From (4:41)
-
StartShow Value As - Column Total vs Row Total (2:23)
-
StartShow Value As % of Row Total and % of Column Total (3:36)
-
StartShow Value As - Percent of Column Total and Percent of Parent Row Total
-
StartShow Value As - Running Total (2:47)
-
PreviewCalculated Field Variance with arrow Up Down (5:24)
-
StartPivot Table - Custom List - Create a list according to your own order Save Time (7:25)
Part 3
Available in
days
days
after you enroll
-
StartExcel Advanced Function - INDEX (4:09)
-
StartAdvanced Function - leverage the strength of MATCH and INDEX (2:42)
-
StartINDEX and MATCH - Part 2 (8:36)
-
PreviewHow to find the lowest supplier price Part 1 (3:42)
-
StartHow to find the lowest supplier price Part 2 (5:05)
-
StartExcel Advanced Function - Variance Analysis using OFFSET and MATCH (4:09)
-
StartDate Related Excel Function (1:35)
-
StartDate Related Function - NETWORKDAY (3:35)
-
StartNested IF (2:49)
-
StartNested IF - Part 2 (2:50)
-
PreviewExcel Macro/VBA - Recording Your first Macro (5:56)
-
StartHow to Save Your Workbook with Macro code (5:41)
-
PreviewCase Study - Generate Salary Slip, Invoice faster than you think using Macro (7:27)
-
StartCase Study - Generate Salary Slip, Invoice faster than you think using Macro Part 2 (6:55)
-
PreviewSearch a Color in a list using SEARCH ISNUMBER XLookup (5:12)
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
This is a monthly subscription program. You can unsubscribe anytime you want. After enrolling, you will immediately have access to this course for as long as you like - across any and all devices you own. Start learning today, success determine not by other, but in your own hand. Thank you for becoming our student today.