Excel: VLOOKUP and XLOOKUP for Beginners

Offered By: LinkedIn Learning

Tags

XLOOKUP Courses Data Analysis Courses Microsoft Office 365 Courses Spreadsheets Courses VLOOKUP Courses

Course Description

Overview

Get a beginner-friendly introduction to VLOOKUP and XLOOKUP, two of Excel’s most powerful functions.

Syllabus

Introduction

Find data quickly in Excel
What can you do with XLOOKUP in Excel?

1. Using Lookup Functions

Creating a simple XLOOKUP
Creating a simple VLOOKUP
Error-proof your formulas

Conclusion

Master more functions and formulas in Excel

Taught by

Jess Stratton

Related Courses

Análisis de datos: Llévalo al MAX()
Delft University of Technology via edX Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Data Processing and Analysis with Excel
Rochester Institute of Technology via edX Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera