Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Excel Crash Course: Lookup Functions (including VLOOKUP)

Chase Raz, University Instructor, Corporate Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
17 Videos (1h 23m)
    • Lesson 1: Welcome to Excel Crash Course: Lookup Functions

      1:44
    • Lesson 2: A refresher on Functions

      4:18
    • Lesson 3: A refresher on entering Functions

      4:31
    • Lesson 4: VLOOKUP

      4:41
    • Lesson 5: VLOOKUP with Exact Match

      4:54
    • Lesson 6: VLOOKUP with Approximate Match

      4:48
    • Lesson 7: (Challenge) Rewards Program

      6:21
    • Lesson 8: Replacing Nested Conditionals with VLOOKUP

      4:57
    • Lesson 9: HLOOKUP

      5:56
    • Lesson 10: (Challenge) Product Comparison

      10:02
    • Lesson 11: LOOKUP

      3:44
    • Lesson 12: Looking to the left with LOOKUP

      4:21
    • Lesson 13: Matching disjointed data with LOOKUP

      4:56
    • Lesson 14: (Challenge) Identifying a Customer

      5:39
    • Lesson 15: Drop down lists via Data Validation

      2:40
    • Lesson 16: Scalable drop downs via Tables

      7:54
    • Lesson 17: Lookup Functions Conclusion

      1:30

About This Class

To follow along with the examples in the course, download the resource folder from the Class Project.  All Excel spreadsheets seen on screen are housed within the downloadable Zip folder.

Class Description

In this fast-paced and no-nonsense tutorial on Excel's most frequently used "lookup" functions, you'll learn how to perform vertical lookups, horizontal lookups, and lookups when tabular data structure can't be ensured.  We'll cover the functions of VLOOKUP, HLOOKUP, and LOOKUP with easy-to-follow and real world examples that fit perfectly with your expected use in the corporate or professional world.

About the Instructor

The Hosting Websites with Amazon Lightsail training series is taught by Chase Raz, a University Instructor, Corporate Trainer, and Consultant with nearly a decade of experience teaching adult students, both academically and vocationally,  in the disciplines of business, technology, and marketing.

--

Students

--

Projects

0

Reviews (0)

Chase Raz

University Instructor, Corporate Trainer

Chase Raz is an instructor of digital marketing and business technology at Full Sail University and a corporate trainer for Polk State College's Corporate College. Chase has almost a decade of experience teaching business and technology topics to a wide array of adult students; from college students to executives. It is Chase's mission to help others achieve their desired success within business. Chase also owns RCR Business Ventures, a firm specializing in venture development.

A.B. Ga...

See full profile