1. Important Date Functions (TODAY, NOW, YEAR, MONTH, DAY, DATE )
2. Age Calculations
3. Calculate End of Probation period using EDATE & WORKDAY
4. Calculate no. of working days between two dates (Networkdays Function)
5. Common Error types in Excel and error handling by Iferror function.
6. Substitute and Find
7. Left, Right and Mid
8. Common IS Functions : Istext, Isnumber, Isblank, Iserror
9. Len and Text