Advertisement
Enroll Link 👉 https://ontap-learning.com/details/8Excel Mastery – From Zero to Professional
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
Week 1: Excel Fundamentals
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: 18th October
🕒 Time: 2 sessions, (Tentative: 9:00 PM – 10:30 PM)
Week 2: Formulas Mastery
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: 25th October
🕒 Time: 2 sessions, (Tentative: 9:00 PM – 10:30 PM)
Week 3: Data Analysis & Reporting
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: 3rd November
🕒 Time: 2 sessions, (Tentative: 9:00 PM – 10:30 PM)
Week 4: Advanced Tools
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: 10th November
🕒 Time: 2 sessions, (Tentative: 9:00 PM – 10:30 PM)
Week 5: Industry Applications
HR, Finance, Merchandising, IE case studies
Final Project: Create dashboard with 3–4 reports
📅 Date: 17th November
🕒 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
Advertisement
Event Venue
Online event, Dhaka, Bangladesh