Excel 2013: Mastering Vlookup and Hlookup Functions
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. So....hit it!
£19.99
Similar Deals
Wilko 1m HDMI Cable Copper, Steel, PVC
£2.75
From Wilko
Huawei P Smart Plus (2019) Midnight Black Unlocked 64GB Very Good
£119.99
From Smart Fone Store
Apple iMac Core (2019) 21.5 i3 3.6GHz 1TB 8GB Silver Very Good
£729.99
From Smart Fone Store
Apple MacBook Air (2015) 13 Core i5 1.6GHz 128GB 4GB - British ...
£379.99
From Smart Fone Store
Apple iMac (2019) 21.5 Core i3 3.6GHz 1TB 8GB Silver Fair
£649.99
From Smart Fone Store
Apple MacBook Pro (2016) 13 Core i5 2.9GHz 256GB 8GB - British ...
£679.99
From Smart Fone Store
Apple iMac (2015) 27 Core i7 4GHz 1TB 8GB Silver Very Good
£2500.00
From Smart Fone Store
Apple iMac (2011) 21.5 Core i5 2.5GHz 500GB 4GB Silver Fair
£289.99
From Smart Fone Store