CASE WHEN & Date Functions: IFS Buckets and YEAR/MONTH Grouping
This lesson is part of the subscription
The first 2 lessons of this course are free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- SELECT & WHERE: Filter Rows with Flags and COUNTIFSFree
- ORDER BY & LIMIT: Rank, Top 3 with LARGE and INDEX/MATCHFree
- GROUP BY with COUNT, SUM & AVG: COUNTIFS, SUMIFS, AVERAGEIFS Tables Pro
- HAVING: Filter Groups on Their Aggregates Pro
- INNER JOIN: XLOOKUP and the #N/A Rows a Join Drops Pro
- LEFT JOIN & NULLs: IFNA, 'Unknown' and Unmatched Rows Pro
- DISTINCT & Duplicates: First-Occurrence COUNTIF Pro
- CASE WHEN & Date Functions: IFS Buckets and YEAR/MONTH Grouping Pro