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

Introduction to Office 365 Development and APIs
Microsoft via edX Office 365: Managing Identities and Services with Hands-on Labs
Microsoft via edX Compliance in Office 365: eDiscovery
Microsoft via edX Compliance in Office 365: Data Governance
Microsoft via edX Microsoft Exchange Server 2016 - 5: Hybrid Topologies with Office 365
Microsoft via edX