Vlookup In Tamil and Hlookup in Tamil(Excel in Tamil)

Duration : 00:36:17

Guru : Rameshwar

22 Learners

Promo video

Complete Course Description

Looking up data in Excel 2013 is a fun thing. Yet many students find it difficult to search for data in Excel due to arcane explanations provided in help files and tutorials.

"Looking up", simply means to search a particular value from a spreadsheet or workbook against a particular value that we know before hand. It can be likened to looking up a word in a dictionary, or a record in a database.

Excel makes it easy to search for values, both in rows and columns. While there are advanced functions also that enable Excel users to search for data "database-style", the HLookup and VLookup functions are their simpler-yet-powerful siblings. 

What Are The Requirements

  • Students will only need to have a very basic understanding of how rows and columns are referenced in Excel

What Am I Going To Get From This Course

  • Understand how data lookups work in Excel

  • Use VLookup and HLookup Functions easily

  • Adopt a Structured Approach when using the lookup functions

What Is The Target Audience

  • Anybody from a newbie to an advanced user can take this course