تفاصيل الدورة

Welcome to VLOOKUP in Google Sheets - Step by Step

Learn one of the most effective functions used to locate data in your Google Sheets tables.

As a new or experienced Google Sheets user, this course will teach you VLOOKUP - a very useful function that will save you time when searching tables.

With this course, you will accomplish the following:

  • Learn what a searchable table is and how to create your own.
  • See how the VLOOKUP function is broken into components and how to utilize each and every component effectively.
  • Create a basic VLOOKUP Google Sheets application.
  • Make your VLOOKUP function interactive to search tables without editing your formula each time.
  • How to use VLOOKUP between two sheets on the same spreadsheet as well as on completely different spreadsheets.
تحديث بتاريخ 02 January, 2018
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Google ابتداءً من الآن. See all courses

قيِم هذه الصفحة