Class 9th - 12th Track6 Weeks CohortTopic-Linked Attendance Enabled
Excel for Career Readiness
Master Microsoft Excel from essential formulas and conditional formatting to modern XLOOKUP, pivot tables, data cleaning, and dynamic executive dashboards.
Key Skills You Will Master:
Microsoft ExcelFormulas & MathXLOOKUP / VLOOKUPPivot TablesData CleaningDashboards
Lead Instructor
Vikramaditya Iyer
Ex-Tech Lead & STEM Mentor (IIT Madras Alum)
Total Program Fee (Full Cohort + Materials)
₹2,499₹3,499Save 29%
Choose Your CohortLive Interactive
Next cohort starting next weekend • 5:00 PM IST
12 Live Hybrid Interactive Sessions
19 Granular Tracked Topics
Downloadable datasets, cheatsheets & Jupyter notebooks
Verifiable Certificate upon 85%+ topic completion
Syllabus Breakdown
Course Structure & Tracked Topics
Click on any module to view live sessions and the exact list of topics tested & tracked for attendance.
Session 1
Session 1: Interface, Navigation & Data Formatting
90 mins
Attendance-Tracked Topics (2):
1Ribbon, Cell Coordinates & Number Formatting
2Data Types, Autofill & Custom Cell Styles
🎯 Hands-on Mini Task:Monthly Family Budget Sheet
Create a cleanly formatted personal expense sheet with currency formats.
Excel Keyboard Shortcuts.pdf
Session 2
Session 2: Formulas & Cell Referencing
90 mins
Attendance-Tracked Topics (2):
1Basic Arithmetic (+, -, *, /) & SUM/AVERAGE
2Relative vs Absolute ($A$1) Cell Referencing
🎯 Hands-on Mini Task:Automated Product Quotation & GST Calculator
Compute unit prices, discounts, and GST using absolute cell referencing.
Session 3
Session 3: Logical Formulas & Conditional Formatting
90 mins
Attendance-Tracked Topics (2):
1IF, AND, OR Logical Statements & Nested Conditions
2Conditional Formatting (Color Scales, Data Bars)
🎯 Hands-on Mini Task:Student Exam Grading & Pass/Fail Status
Auto-grade student percentages using nested IF statements.
Session 4
Session 4: Aggregation Functions (COUNTIF / SUMIF)
90 mins
Attendance-Tracked Topics (1):
1COUNT, COUNTA, COUNTIF, and SUMIF Calculations
Session 5
Session 5: Sorting, Filtering & Data Validation
90 mins
Attendance-Tracked Topics (2):
1Multi-Level Sorting & Advanced Custom Filters
2Data Validation Lists & Input Error Alerts
🎯 Hands-on Mini Task:Employee Request Form with Dropdown Validations
Enforce strict dates and department dropdown validation rules.
Session 6
Session 6: Lookup Functions (VLOOKUP & XLOOKUP)
90 mins
Attendance-Tracked Topics (2):
1VLOOKUP Exact vs Approximate Matches & IFERROR
2Modern XLOOKUP with Multiple Return Columns
🎯 Hands-on Mini Task:Product Pricing & Barcode SKU Lookup Tool
Match SKU codes to product pricing and suppliers with IFERROR handling.
Session 7
Session 7: Text & Date Manipulation Functions
90 mins
Attendance-Tracked Topics (2):
1TEXTJOIN, LEFT, RIGHT, MID, TRIM, PROPER
2DATE, DATEDIF, and Real-time Age Calculations
Session 8
Session 8: Data Cleaning & Deduplication
90 mins
Attendance-Tracked Topics (1):
1Text-to-Columns Wizard, Flash Fill & Deduplication
Intermediate Milestone Project: Retail Inventory & Reorder Tracker
A multi-sheet workbook matching sales to supplier catalogs with XLOOKUP and auto-alerting stock deficits.
Deliverable: Cleaned spreadsheet with automated lookup catalogs and low-stock indicators.
Session 9
Session 9: Charts & Visual Storytelling
90 mins
Attendance-Tracked Topics (1):
1Bar, Line, Combination Charts & Dual Axes
🎯 Hands-on Mini Task:5-Year Revenue & Margin Dual-Axis Chart
Plot sales revenue on primary axis and profit margin % on secondary axis.
Session 10
Session 10: Pivot Tables Deep Dive
90 mins
Attendance-Tracked Topics (2):
1Building Pivot Tables, Grouping Dates & % of Total
2Calculated Fields & Multi-dimensional Summary
Session 11
Session 11: Pivot Charts, Slicers & Dashboard Layout
90 mins
Attendance-Tracked Topics (1):
1Connecting Slicers to Multiple Pivot Tables
Session 12
Session 12: Executive Capstone Presentation
90 mins
Attendance-Tracked Topics (1):
1Dashboard Presentation, Formatting & PDF Export
Graduation Capstone
Executive E-Commerce Sales & Profitability Dashboard
Design a dynamic Excel dashboard analyzing 50,000+ sales records across product categories and regions with synchronized slicers.
Deliverable:
Multi-tab interactive Excel Workbook + PDF Executive Summary
What You Will Be Able To Do
Master essential business formulas (SUMIFS, COUNTIFS, IF, XLOOKUP)
Automate data cleaning and remove errors from messy imported spreadsheets
Build multi-source pivot tables with calculated fields and grouping
Create interactive executive dashboards connected with slicers and timelines
Prerequisites
No prior experience needed. Microsoft Excel or Google Sheets.
Unsure if this fits your current grade?
Schedule a 10-minute discovery call with our academic advisor.