Week 1
-
Cell Reference Part 1 (4:26)
-
Cell Reference Part 2 (2:50)
-
Grouping several rows together using Group or Outline (5:32)
-
Using IF Function to Check Business Requirement (6:04)
-
Using IF Function - Checking a List of Value (8:34)
-
Using IF Function Part 3 - Calculate a different bonus based on business requirement (6:11)
-
Using Cell Reference - another example (2:14)
-
Basic IF Function 1 (5:10)
-
Basic IF Function 02 (3:03)
-
Basic IF Function 03 (4:52)
-
Basic Function IF 04 (1:55)
-
How to calculate School Exam Grade using Absolute Cell Reference and IF function (6:51)
-
Using AND Function - Basic Understanding (5:57)
-
The Smarter way to Error Checking using Equal Operator (4:10)
-
using IFError to avoid showing potential Excel error #DIV/0 (3:21)
-
Aging - Conditional Formatting (4:32)
Time Saving Shortcut
Week 2
-
VLookup TRUE Type (4:37)
-
VLOOKUP Function (5:26)
-
VLookup Function - Example 2 (4:57)
-
VLookup - Lookup from Other Workbook and Learn MATCH (4:57)
-
VLookup + Match - another example (4:57)
-
Creating a Drop Down List using Data Validation (4:31)
-
Drop down List - Referring Source from another sheet (7:36)
-
Dropdown List - Another Example (2:36)
-
How to Remove Data Validation and Named Range (3:37)
-
XLookup - available in Office 365 (7:10)
-
XLookup - Part 2 (6:17)
-
Understand OFFSET - Part 1 (6:24)
-
Understand OFFSET - part 2 more dynamic with Match (5:27)
-
Understand OFFSET - part 3 - Solution to my student SUM a range based on condiitions (5:57)
-
Dynamic Picking the right column using MATCH and INDEX (5:25)
Week 3
-
Searching Words using Wildcard Pattern (6:37)
-
Protecting Your Data - Protect Worksheet (6:42)
-
Protecting Your Data - Hiding Formula (6:03)
-
Basic of Hyperlink (4:21)
-
Hyperlink - A more practical example to track personal finance (8:58)
-
Create a Table of Content using HYPERLINK and INDEX (4:10)
-
How to check Invoice overdue using IF (1:55)
-
Excel Function - Subtotal (4:16)
-
Excel Function Subtotal 9 vs 109 (3:57)
-
Text Function - UPPER, LOWER (9:46)
-
Using Excel Table (4:05)
-
Excel Table - Using Reference Operator (6:44)
-
Date related Function - YearFrac, Weekday, Today and more (10:57)
Charting
