01Class 1: Introduction to Excel for Data Analysis
- Overview of Excel interface
- Navigating sheets efficiently
- Math & statistical functions (SUM, AVERAGE, COUNT)
- Logical functions (IF, AND, OR)
- Text functions for manipulation
- VLOOKUP, VLOOKUP
02Class 2: Advanced Formulas & Dashboards Using Excel
- INDEX MATCH
- SUMIF, COUNTIFS, nested functions
- Power Query: import, transform, merge, append
- Dynamic dashboards
- Pivot tables from multiple sources
- Slicers, combo charts, layout optimization
03Class 3: Excel AI, Project, Kaggle & Github Introduction
- AI-assisted data cleaning & transformation
- Excel with AI project
- Kaggle and Github optimization
04Class 4: Introduction to SQL
- Overview of SQL & databases
- Basic syntax, SELECT, WHERE
- Creating & modifying tables (CREATE/ALTER)
- Understanding constraints