vlookup uncoverd mega course in tamil

Categories: Excel, Vlookup
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Mastering VLOOKUP in Microsoft Excel – 30 Practical Types (Tamil) is a complete, step-by-step Excel course designed for beginners, office employees, and students who want to confidently use VLOOKUP in real-world scenarios.

In this course, you will learn VLOOKUP from basics to advanced, explained in simple Tamil + English (Thanglish) with clear examples, real office use cases, and practice files. Each lesson focuses on practical application, not theory.

You will learn how to:

  • Use VLOOKUP correctly with exact and approximate matches

  • Handle common errors like #N/A using IFERROR

  • Perform reverse VLOOKUP (Right to Left)

  • Work with dynamic columns using MATCH

  • Build real-time projects like salary lookup, grade systems, dashboards, and reports

This course includes 30 structured lessons, a 30-sheet practice Excel workbook, and course notes PDF, making you job-ready and interview-ready.

👉 No complex English. No confusion. Only practical Excel skills.

Show More

What Will You Learn?

  • ou will learn VLOOKUP from basics to advanced, explained in simple Tamil + English (Thanglish) with clear examples, real office use cases, and practice files. Each lesson focuses on practical application, not theory.

Course Content

Mastering VLOOKUP in Microsoft Excel – 30 Practical Types

  • Vlookup syntex
    02:49
  • Find Employee Name by ID
    07:20
  • Find product price
    03:51
  • Find department using name
    02:59
  • Vlookup with numbers
    01:57
  • vlookup with text
    02:41
  • vlookup with approximate match
    03:23
  • approximate match for discount
    04:15
  • Vlookup Errors Explained
    02:53
  • vlookup with iferror
    02:09
  • case sensitive in vlookup
    01:59
  • Vlookup with another sheet
    02:30
  • Vlookup with Another workbook
    03:16
  • vlookup with absolute reference
    02:40
  • Vlookup with named range
    02:49
  • vlookup with tables
    03:33
  • Vlookup with Match function
    03:57
  • Two way vlookup
    02:03
  • vlookup with choose function
    02:43
  • vlookup right to left
    02:49
  • Nested vlookup
    04:18
  • Multiple criteria Vlookup
    02:35
  • vlookup with helper column
    02:25
  • vlookup with wildcards
    04:45
  • vlookup with dates
    02:08
  • vlookup with text function
    02:25
  • vlookup real time project
    02:21
  • vlookup grade automation
    01:29
  • vlookup stock and price
    01:23
  • vlookup with dropdown
    02:15

Interview questions

Student Ratings & Reviews

No Review Yet
No Review Yet