https://www.youtube.com/watch?v=XRPyj7cKVsQ

00:00 — Intro and sponsor (Udemy)

01:00 — Course scope and setup

02:00 — MAX and MIN overview

03:00 — Applying MAX and MIN to dates and salaries

04:00 — Troubleshooting ranges and intro to IF/IFS

05:00 — IF function: age > 30 example

06:00 — IFS: multiple conditions

07:00 — IFS example with roles

08:00 — IFS continued, intro to LEN

09:00 — LEN: validate IDs and phone numbers

10:00 — LEN continued, LEFT/RIGHT intro

11:00 — LEFT: take first N characters

12:00 — RIGHT: take last N characters

13:00 — Extract year from date with RIGHT

14:00 — Why TEXT is needed for dates

15:00 — TEXT: convert dates to text format

16:00 — Validate TEXT output by extracting year