Announcement bar drops down here to inform users of the latest news and sales!

Business microlearning from Japan’s No1 MBA

Excel Functions & Formulas: Lookup & Reference

9 minutes (1 section)

Course Description

Excel’s lookup and reference functions empower you to dynamically manipulate and retrieve data from spreadsheets.
They streamline tasks, save time, and enable quick analysis.

In this course, you’ll discover how to:
• Use the VLOOKUP, HLOOKUP, MATCH, INDEX and CHOOSE functions,
• And, use the VLOOKUP function to look up a value in a table.

Join us, and utilize these functions to excel in your data management tasks!

Share this course:

Related Courses

Managing Workplace Harassment

Learn to identify, address, and prevent workplace harassment to create a safe, respectful, and legally compliant professional environment for everyone.

4 videos

8 min

Office Sensei: Season 2 | Ep 5: Honne & Tatemae

What happens when you drop the polite mask? Learn the Japanese concepts of Honne (true feelings) and Tatemae (public face).

1 videos

9 min

Intersectionality

See how considering intersectionality in the workplace can build more inclusive, equitable, and responsive organizational practices.

4 videos

8 min

Office Sensei: Season 2 | Ep 4: Senpai / Kohai

Dave wanders into a mirror universe and learns the Japanese Senpai-Kohai dynamic and how mutual respect drives team innovation.

1 videos

17 min

Onboarding

Learn how effective onboarding helps new employees gain clarity, build confidence, and contribute successfully from the start.

4 videos

11 min