Objective:
Make students proficient in Excel for data analysis, reporting, and professional job readiness.

Duration & Format:
5 weeks | 2 sessions/week | Tentative: 9:00 PM – 10:30 PM

• Interface, shortcuts, formatting
• Data cleaning basics
• AI Support: How to ask AI “What does this Excel tool do?” or “Give me a shortcut list”
• Assignment: Format & clean, messy data

📅 Date: 3rd January
🕒 Time: 2 sessions, (Tentative: 9:00 PM – 10:30 PM)

• IF, Nested IF, COUNTIF, SUMIF
• VLOOKUP, HLOOKUP, INDEX-MATCH
• AI Support: Use AI to explain formulas in plain language (“Explain COUNTIF as if I’m 12”)
• Assignment: Create attendance tracker

📅 Date: 10th January 
🕒 Time: 2 sessions, (Tentative: 9:00 PM – 10:30 PM)

• Pivot Tables & Pivot Charts
• Conditional Formatting
• AI Support: How to ask AI to suggest the “best chart” for a dataset
• Assignment: Build simple sales dashboard

📅 Date: 17th January 
🕒 Time: 2 sessions, (Tentative: 9:00 PM – 10:30 PM)

• Text functions, date functions
• What-if analysis, Goal Seek
• Intro to Macros
• AI Support: Let AI generate formulas or give tips for faster solutions
• Assignment: Automate report formatting

📅 Date: 24th January 
🕒 Time: 2 sessions, (Tentative: 9:00 PM – 10:30 PM)

• HR, Finance, Merchandising, IE case studies
• Final Project: Create dashboard with 3–4 reports

📅 Date: 31th January 
🕒 Time: 2 sessions, (Tentative: 9:00 PM – 10:30 PM)

Expected Outcomes:

• Hands-on Excel skills for jobs/internships
• Ability to create professional dashboards & reports