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

Business microlearning from Japan’s No1 MBA

Edge

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

The KAISHA: The Business Reinvention of Japan

Learn how some Japanese companies are competing globally by pursuing an “aggregate niche strategy” in this panel from the 2025 G1 Global Conference.

1 videos

61 min

From Tokyo to the World: The Globalization of Japanese Pop Culture

Hear how Japanese pop culture continues to shape the world and the challenges of industry today in this panel from the 2025 G1 Global Conference.

1 videos

58 min

How to End Bad Meetings

Learn how to make meetings focused, purposeful, and worth everyone’s time, while avoiding the hidden costs of bad ones.

1 videos

2 min

From Outlier to Example: Japan’s Social Cohesion in a Divided World

Learn how Japan’s social cohesion model may serve as a global example in this panel from the 2025 G1 Global Conference.

1 videos

60 min

The Next Wave of AI: LLMs to Agentic Systems

Learn about the coming shift from LLMs to AI agents that can transform business operations in this panel from the 2025 G1 Global Conference.

1 videos

61 min