Class / Schedule

-

Information Technology

Excel Using Lookup and Reference Functions: 2013/2016 (1 Day)

01-04-T936

Do you spend too much time looking for information in large amounts of data in your Excel spreadsheets?  Want to free up some of that time?  When you want to pull information from an Excel worksheet, Excel lookup functions are handy solutions.  Their ability to dynamically lookup and retrieve information can be a game-changer for many users!
Participants in this one-day class will learn how to perform powerful information gathering in an Excel range or table, utilizing lookup and reference functions as well as other related time-saving formulas and techniques. Participants should have a good understanding of and experience with Excel prior to this class.



Performance Objectives:
  Upon completion of this course, participants should be able to:

  • Identify VLOOKUP vs. HLOOKUP functions
  • Use a lookup function to find an exact match for a value and then return another value
  • Use a lookup function to find an approximate match in a range, and then return another value
  • Use INDEX and MATCH together and with VLOOKUP to look up values based on two variables
  • Use LEFT and RIGHT in conjunction with VLOOKUP
  • Use LARGE and SMALL to locate the Nth largest or smallest value in a range
  • Utilize the Data Validation tools to enhance the use of VLOOKUPS
  • Use Range names to simplify lookup and reference functions
  • Recognize and handle typical lookup errors

Competencies covered in this course:  VLOOK Up functions in Excel and working with large amounts of data.



Intended Audience:
      Anyone who works with large amounts of data in Excel



Prerequisites:
To be successful in this course, you should be familiar with using personal computers, the mouse and keyboard. You should be able to use Windows to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you have a good understanding of Excel.

Scheduled Class Location and Dates
City / Facility Date and Time Course Cost Cancel Date Instructor
1 Lacey

SPSCC - LACEY
4220 6th Ave SE Bldg. 1
Lacey, WA 98503
  • May 29 2019 8:00am-4:30pm
$275.00 Sun, 05/12/2019 - 17:00 Debbie Lonborg