MODULE 01
Excel for Data Analytics + AI
Excel Fundamentals
- Excel Interface
- Data Types
- Data Cleaning
- Sorting & Filtering
- Data Formatting
Core Functions
- IF Function
- SUMIFS
- COUNTIFS
- VLOOKUP
- XLOOKUP
- INDEX MATCH
- Text Functions
- Date Functions
Advanced Excel
- Pivot Tables
- Pivot Charts
- Conditional Formatting
- Data Validation
- Power Query Basics
- Excel Dashboards
AI Tools for Excel
- ChatGPT
- SheetGPT
- OpenAI API
- AI-Powered Analytics Summaries

































































