VLOOKUP is the most-asked Excel formula in interviews, and this free tutorial teaches it properly: the four arguments, why FALSE (exact match) matters, the leftmost-column rule, fixing the #N/A error with IFERROR, and when to use the modern XLOOKUP or the timeless INDEX-MATCH instead. Each comes with a predict-the-output practice so you verify your understanding. Part of the free Excel & Spreadsheets for Jobs course; works in Excel, Google Sheets and LibreOffice.
This free course is built for school students preparing for the CBSE syllabus, college students who need Excel for internships and job applications, working professionals who use spreadsheets daily, and small-business owners managing inventory or accounts. If you have ever Googled vlookup tutorial (free) — with live practice and bounced off paid-subscription paywalls or content that assumes you already know everything — this is the course for you.
This page is part of our flagship free course, Excel & Spreadsheets for Jobs. The full course is delivered as short, focused lessons, each with bilingual narration (English and Hinglish), interactive practice widgets, and a clear before-and-after so you can feel yourself getting better. You can pause for weeks and pick up exactly where you left off — your progress is saved.
One phone-number signup unlocks every course on Techwave Academy: AI Bootcamp, Python for Class 4 / 6 / 8 / 10 / CBSE 12, Git, Linux, Spoken English, IOI Prep, Foundation Bootcamp, Blind 75, NeetCode 150, Claude Mastery, Tableau, Power BI, SQL, and Excel. Yes — all 18, forever free.
No. Every lesson works in free Excel for the Web, Google Sheets, or LibreOffice Calc. Where there is a syntax difference (e.g. XLOOKUP vs INDEX-MATCH), we show both.
Yes — the formulas and pivot-table skills covered are exactly what data-entry, analyst, accounts, and BPO roles ask in interviews. Pair it with our free SQL course for a full data-analyst profile.
About 20 hours of focused work. Most learners finish in 2-4 weeks of 30-60 minutes a day.
Yes. After finishing all 36 lessons you can download a free completion certificate with your name and a verification link.
Yes. Week 1 starts with what a cell is and the Name Box. Every formula has an interactive "predict the output" check so you build intuition, not just copy steps.
Click below to open Excel & Spreadsheets for Jobs. You will land on the course dashboard, see the week-by-week plan, and can start Lesson 1 immediately. No trial period, no payment screen, no upgrade pop-ups — ever.