Week 1: Foundations

Guru Charan Pathalla

Week 1 Overview

This week establishes the foundation for both Excel and SQL. You'll learn core concepts that everything else builds upon.

Key Focus Areas: Basic formulas, functions, filtering, lookups, and SELECT queries

This Week's Learning Path

Click any day below to view detailed lessons, practice exercises, and assignments:

📚 Day 1: Excel - Formulas & Basic Functions

Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments

📚 Day 2: SQL - SELECT & Aggregates

Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments

📚 Day 3: Excel - Filtering & Conditional Functions

Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments

📚 Day 4: SQL - WHERE Clause & Filtering

Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments

📚 Day 5: Excel - VLOOKUP & XLOOKUP

Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments

Have feedback or questions?