Week 3 Overview
Move to intermediate concepts with date handling, window functions, and what-if analysis for more sophisticated data work.
Key Focus Areas: Date functions, window functions (ROW_NUMBER, RANK, LAG, LEAD), Power Query
This Week's Learning Path
Click any day below to view detailed lessons, practice exercises, and assignments:
📚 Day 11: Excel - Date Functions (TODAY, DATEDIF, NETWORKDAYS, EOMONTH)
Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments
📚 Day 12: SQL - Date Functions & Window Functions Part 1 (ROW_NUMBER, RANK)
Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments
📚 Day 13: Excel - What-If Analysis (Goal Seek, Data Tables, Scenarios)
Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments
📚 Day 14: SQL - Window Functions Part 2 (LAG, LEAD, Running Totals)
Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments
📚 Day 15: Excel - Power Query Basics + WEEK 3 TEST
Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments