Master data lookups in Excel 2013 using the VLookup and HLookup functions. Will help newbies and advanced users, alike.
Looking up data in Excel 2013 is a fun thing. Yet many students find it difficult to search f data in Excel due to arcane explanations provided in help files and tutials.
"Looking up", simply means to search a particular value from a spreadsheet wkbook against a particular value that we know befe hand. It can be likened to looking up a wd in a dictionary, a recd in a database.
Excel makes it easy to search f values, both in rows and columns. While there are advanced functions also that enable Excel users to search f data "database-style", the HLookup and VLookup functions are their simpler-yet-powerful siblings. Simpler? Yeah! Because, why should you use a cannon to shoot a fly?
After this course, whether you want to calculate grades in Gradebooks, design Directies draw-up Invoices, you'll be able to do it on your own, and in a jiffy. The course spans about 40 mins, with live examples, practice wkbooks to follow along, and chalk board style logic-behind teaching.
I recommends Buy premimum account for High speed+parallel downloads!