vlookup uncoverd mega course in tamil
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/Ausing 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.
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