Practice Files:
Tricks:
- Age Calculator
- Index-Match-Lookup combined example 1
- Conditional Formatting - Training Date Expire and Renewal
Tricks:
- Get Numerical result by matching 3 conditions through SUMIFS, LOOKUP, SUMPRODUCT and SUM
- Split a TEXT into Column after a specific character each time in Excel
- Lookup a single cell but match with 2 cells