If you are planning to step up your proficiency in Excel, you should learn how to use the look up functions. These functions are commonly used on tables that act like a database. While databases have SQL queries, which is challenging especially for non-programmers, Excel has these simple look up functions and the most widely used are VLOOKUP, HLOOKUP and LOOKUP.