Excel 2013: Mastering Vlookup and Hlookup Functions
MP4 | Video: 1280x720 | 72 kbps | 44 KHz | Duration: 1 Hours | 165 MB
Genre: eLearning | Language: English
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 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. 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 Directories or 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 workbooks to follow along, and chalk board style logic-behind teaching.
http://www.nitroflare.com/view/9FEB29C809FFE4B/uuc63.Excel.2013.Mastering.Vlookup.and.Hlookup.Functions.part1.rar
http://www.nitroflare.com/view/CB78442E729E5EA/uuc63.Excel.2013.Mastering.Vlookup.and.Hlookup.Functions.part2.rar
http://rapidgator.net/file/ffdb93171e373272620d0867dedb98e1/uuc63.Excel.2013.Mastering.Vlookup.and.Hlookup.Functions.part1.rar.html
http://rapidgator.net/file/ea4c4dc5386a923f72a039e7ab8e30d1/uuc63.Excel.2013.Mastering.Vlookup.and.Hlookup.Functions.part2.rar.html
http://uploaded.net/file/xzq74btl/uuc63.Excel.2013.Mastering.Vlookup.and.Hlookup.Functions.part1.rar
http://uploaded.net/file/qsl7bh2k/uuc63.Excel.2013.Mastering.Vlookup.and.Hlookup.Functions.part2.rar