Loading...

Course Description

In a large worksheet, it is advantageous to be able to find specific data for display and/or use in calculations.  LOOKUP, VLOOKUP, and HLOOKUP are functions in Excel that can help accomplish this.  This half-day seminar will show you how to master these three functions – and produce amazing results.

See specific content information below in sections "Expected Outcomes" and "Attend and You Will Learn."

Related Courses

Other Courses

Who Should Attend

This course is designed for experienced Excel users who are seeking to advance their data analysis capabilities by using Excel's LOOKUP, VLOOKUP, and HLOOKUP functions.

Attend and You Will Receive

Upon successful completion of this course, you will receive a certificate of completion from NC State University.

Prerequisites

To ensure your success in this course, you should have experience working with Excel. You should already understand spreadsheet concepts and be comfortable creating basic worksheets. You can obtain this level of skill and knowledge by taking Excel Level 1.

Attend and You Will Learn / Expected Outcome

Expected Outcomes

Upon successful completion of this course, you will be able to use Excel's LOOKUP, VLOOKUP, and HLOOKUP functions to analyze your raw data.

 

Attend And You Will Learn

  • LOOKUP
  • VLOOKUP
  • HLOOKUP
  • Using VLOOKUP with other functions
  • Shortcuts to use
  • Case studies
Loading...

Enroll Now - Select a section to enroll in

Section Title
Excel Lookups
Type
In-Class
Days
W
Time
1:00PM to 4:15PM
Dates
Mar 11, 2020
Schedule and Location
Contact Hours
3.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $195.00