Excel for Career Readiness
Best Excel course for students & career switchers — Learn XLOOKUP and Data Cleaning online
Master Microsoft Excel from essential formulas and conditional formatting to modern XLOOKUP, pivot tables, data cleaning, and dynamic executive dashboards.
Course Structure — Learn XLOOKUP and Data Cleaning online
The best Excel course for students and professionals. Click on any module to inspect live sessions and the exact syllabus tested & tracked for attendance.
Session 1: Interface, Navigation & Data Formatting
Create a cleanly formatted personal expense sheet with currency formats.
Session 2: Formulas & Cell Referencing
Compute unit prices, discounts, and GST using absolute cell referencing.
Session 3: Logical Formulas & Conditional Formatting
Auto-grade student percentages using nested IF statements.
Session 4: Aggregation Functions (COUNTIF / SUMIF)
Session 5: Sorting, Filtering & Data Validation
Enforce strict dates and department dropdown validation rules.
Session 6: Lookup Functions (VLOOKUP & XLOOKUP)
Match SKU codes to product pricing and suppliers with IFERROR handling.
Session 7: Text & Date Manipulation Functions
Session 8: Data Cleaning & Deduplication
A multi-sheet workbook matching sales to supplier catalogs with XLOOKUP and auto-alerting stock deficits.
Session 9: Charts & Visual Storytelling
Plot sales revenue on primary axis and profit margin % on secondary axis.
Session 10: Pivot Tables Deep Dive
Session 11: Pivot Charts, Slicers & Dashboard Layout
Session 12: Executive Capstone Presentation
Executive E-Commerce Sales & Profitability Dashboard
Design a dynamic Excel dashboard analyzing 50,000+ sales records across product categories and regions with synchronized slicers.
What You Will Be Able To Do — Practical Excel Mastery
Prerequisites
No prior experience needed. Microsoft Excel or Google Sheets.