Excel - XLOOKUP (Basic metrics) Tutorial
In this video, you will learn about how to search and find what you need using Microsoft 365. The video covers the usage of OneDrive, Yammer, and Delve to help you locate and access documents, collaborate with colleagues, and stay updated on the latest information.
This will help you improve your productivity and efficiency in finding relevant content within the Microsoft 365 environment.
- 4:19
- 1019 views
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 3161 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 2930 times
-
3D Maps
- 1:41
- Viewed 2521 times
-
Manage conditional formatting
- 4:30
- Viewed 2511 times
-
Create a combo chart
- 1:47
- Viewed 2388 times
-
The SUMIF function
- 5:27
- Viewed 2364 times
-
Functions and formulas
- 3:24
- Viewed 2312 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 2280 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 2273 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 2264 times
-
The SUM function
- 4:37
- Viewed 2246 times
-
More complex formulas
- 4:17
- Viewed 2234 times
-
Advanced formulas and references
- 4:06
- Viewed 2230 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 2224 times
-
More print options
- 5:59
- Viewed 2223 times
-
Introduction to Excel
- 0:59
- Viewed 2222 times
-
Using functions
- 5:12
- Viewed 2214 times
-
Customize charts
- 4:28
- Viewed 2204 times
-
Manage drop-down lists
- 6:12
- Viewed 2202 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 2132 times
-
New Chart types
- 1:52
- Viewed 2126 times
-
Freeze panes in detail
- 3:30
- Viewed 2122 times
-
Start using Excel
- 4:22
- Viewed 2115 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2113 times
-
AutoFill
- 2:55
- Viewed 2108 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 2103 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 2100 times
-
Drop-down list settings
- 4:14
- Viewed 2099 times
-
AutoFilter details
- 3:27
- Viewed 2097 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2077 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 2068 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 2065 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 2064 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2062 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 2055 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2055 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2050 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 2049 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 2042 times
-
Look up values on a different worksheet
- 2:39
- Viewed 2037 times
-
Header and footer details
- 3:41
- Viewed 2032 times
-
Sort details
- 4:46
- Viewed 2013 times
-
IF with AND and OR
- 3:35
- Viewed 2013 times
-
Operator order
- 2:04
- Viewed 2012 times
-
Assign a button to a macro
- 2:49
- Viewed 2006 times
-
A closer look at the ribbon
- 3:55
- Viewed 2003 times
-
Work with macros
- 4:40
- Viewed 1992 times
-
Add numbers
- 2:54
- Viewed 1982 times
-
Advanced filter details
- 4:13
- Viewed 1982 times
-
A first look at Excel 2016
- 3:22
- Viewed 1981 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 1980 times
-
Insert columns and rows
- 4:16
- Viewed 1976 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 1974 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 1971 times
-
Basic math
- 2:28
- Viewed 1969 times
-
Print worksheets and workbooks
- 1:07
- Viewed 1967 times
-
One click Forecasting
- 1:01
- Viewed 1963 times
-
Use conditional formatting
- 2:02
- Viewed 1963 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 1960 times
-
Insert headers and footers
- 2:02
- Viewed 1957 times
-
Ink Equation
- 0:41
- Viewed 1925 times
-
Input and error messages
- 2:52
- Viewed 1918 times
-
Improved version history
- 0:51
- Viewed 1914 times
-
Copy a chart
- 2:59
- Viewed 1908 times
-
Subtract time
- 3:58
- Viewed 1904 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 1901 times
-
Save your macro
- 2:59
- Viewed 1901 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 1896 times
-
AVERAGEIF function
- 3:04
- Viewed 1894 times
-
Save and print an Excel workbook
- 1:53
- Viewed 1884 times
-
Cell references
- 1:34
- Viewed 1878 times
-
Add formulas and references
- 2:52
- Viewed 1870 times
-
IFS
- 1:05
- Viewed 1869 times
-
Copying formulas
- 3:00
- Viewed 1845 times
-
Get going fast
- 1:38
- Viewed 1842 times
-
Conditionally format text
- 2:12
- Viewed 1832 times
-
Freeze or lock panes
- 1:06
- Viewed 1830 times
-
Conditionally format dates
- 2:38
- Viewed 1828 times
-
TEXTJOIN
- 0:47
- Viewed 1827 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1814 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1811 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1805 times
-
Weighted average
- 2:06
- Viewed 1789 times
-
Save, publish, and share
- 2:22
- Viewed 1787 times
-
Average a group of numbers
- 2:01
- Viewed 1766 times
-
Share documents
- 1:13
- Viewed 1762 times
-
How to create a table
- 2:11
- Viewed 1759 times
-
Use slicers to filter data
- 1:25
- Viewed 1756 times
-
Drop-down lists
- 0:55
- Viewed 1738 times
-
Advanced IF functions
- 3:22
- Viewed 1735 times
-
How things are organized
- 1:58
- Viewed 1732 times
-
Create a chart
- 0:52
- Viewed 1729 times
-
CONCAT
- 0:51
- Viewed 1717 times
-
Edit a macro
- 3:29
- Viewed 1712 times
-
Flash Fill
- 2:59
- Viewed 1700 times
-
Sort and filter data
- 1:38
- Viewed 1672 times
-
SWITCH
- 1:03
- Viewed 1665 times
-
Nested IF functions
- 3:30
- Viewed 1660 times
-
Microsoft Search
- 0:34
- Viewed 1643 times
-
Page numbers in depth
- 3:06
- Viewed 1626 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 1598 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1586 times
-
Map Chart in Excel
- 0:31
- Viewed 1584 times
-
Funnel Chart
- 0:33
- Viewed 1441 times
-
Accessibility in Excel
- 1:12
- Viewed 1381 times
-
Check Accessibility in Excel
- 1:51
- Viewed 1341 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1072 times
-
Change chart type
- 1:29
- Viewed 1063 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1041 times
-
Text before & after Function
- 4:57
- Viewed 992 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 985 times
-
Create dynamic drop down lists
- 3:26
- Viewed 975 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 894 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 725 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 100 times
-
Format Data with Copilot
- 1:52
- Viewed 95 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 92 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 92 times
-
Creating a Report
- 2:54
- Viewed 4669 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2113 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2077 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2062 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2050 times
-
Preparing, cleaning and transforming your Data
- 4:42
- Viewed 2039 times
-
Recovering your Data from different sources
- 3:26
- Viewed 1996 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 1853 times
-
Introduction to the Query Editor
- 2:33
- Viewed 1842 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 1820 times
-
Creating your Datasets
- 2:26
- Viewed 1800 times
-
Customising your Visuals
- 2:58
- Viewed 1728 times
-
Improved version history
- 0:51
- Viewed 1684 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 1670 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 1650 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 1595 times
-
Customising your Report
- 3:12
- Viewed 1580 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1041 times
-
Manage life cycle of a topic
- 1:44
- Viewed 1038 times
-
Check and share your form results
- 2:42
- Viewed 997 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 894 times
-
Manage video settings
- 1:27
- Viewed 839 times
-
Optimize Meetings with Viva Insights
- 1:58
- Viewed 780 times
-
Analyze your network and communication habits
- 2:17
- Viewed 686 times
-
Receiving a briefing email from Viva Insights
- 0:54
- Viewed 680 times
-
Copilot in Teams Conversations
- 2:47
- Viewed 101 times
-
Summarize Your Email Exchanges with Copilot
- 0:53
- Viewed 98 times
-
Copilot After Teams Meetings
- 1:43
- Viewed 97 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 94 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 94 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 90 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 90 times
-
Copilot During Teams Meetings
- 3:29
- Viewed 85 times
-
Creating a Form with Copilot
- 1:57
- Viewed 94 times
-
What can Copilot do for you ?
- 2:37
- Viewed 96 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 92 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 100 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 92 times
-
Format Data with Copilot
- 1:52
- Viewed 95 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 94 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 99 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 118 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 121 times
-
Use the Copilot Conversation Pane in Word
- 1:56
- Viewed 100 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 99 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 90 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 89 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 95 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 137 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 90 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 94 times
-
Generate and Organize Ideas with Copilot
- 2:06
- Viewed 88 times
-
Summarize Your Email Exchanges with Copilot
- 0:53
- Viewed 98 times
-
Optimize Email Writing with Copilot Coaching
- 1:41
- Viewed 95 times
-
Draft an Email with Copilot
- 2:35
- Viewed 105 times
-
Copilot After Teams Meetings
- 1:43
- Viewed 97 times
-
Copilot During Teams Meetings
- 3:29
- Viewed 85 times
-
Copilot in Teams Conversations
- 2:47
- Viewed 101 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 94 times
-
Chat, Get Inspired, and Search with Copilot
- 3:26
- Viewed 88 times
-
How to Access Copilot
- 1:32
- Viewed 126 times
-
Manage priority people
- 0:24
- Viewed 124 times
-
Finding Help?
- 0:56
- Viewed 329 times
-
Chancing Your Status
- 0:40
- Viewed 355 times
-
Enabling Mobile Notifications
- 1:28
- Viewed 317 times
-
Enabling Subtitles During a Meeting
- 1:28
- Viewed 347 times
-
Sharing Content in a Meeting
- 0:41
- Viewed 308 times
-
Creating and Joining a Meeting
- 1:22
- Viewed 490 times
-
File Management
- 1:04
- Viewed 325 times
-
Managing Teams and Channels
- 2:15
- Viewed 322 times
-
Posting in a Channel
- 2:15
- Viewed 355 times
-
Creating a Channel
- 2:05
- Viewed 301 times
-
Creating or Joining a Team
- 1:11
- Viewed 475 times
-
Disabling Conversation Notifications
- 0:27
- Viewed 323 times
-
Responding or Reacting to a Message
- 1:01
- Viewed 471 times
-
Starting a Conversation
- 0:53
- Viewed 333 times
-
Searching for Items or People
- 0:30
- Viewed 299 times
-
Interface Overview
- 1:10
- Viewed 361 times
-
Finding and Installing Teams for Mobile
- 0:57
- Viewed 341 times
-
Importing and Processing Images with Copilot Edge
- 1:12
- Viewed 339 times
-
Optimizing the Edge Experience with Copilot
- 0:42
- Viewed 329 times
-
Summarizing a Video with Copilot Edge
- 0:53
- Viewed 448 times
-
Summarizing a PDF with Copilot Edge
- 0:53
- Viewed 1117 times
-
Generating an Image with Copilot Edge
- 0:58
- Viewed 383 times
-
Composing a Text with Copilot Edge
- 1:37
- Viewed 359 times
-
Using Conversational AI Copilot Edge
- 1:13
- Viewed 353 times
-
Personal Account vs. Professional Account
- 0:56
- Viewed 516 times
-
Managing Privacy in Copilot Edge
- 0:43
- Viewed 418 times
-
Accessing Copilot in Microsoft Edge
- 0:35
- Viewed 531 times
-
Enabling Copilot Edge in the Enterprise Environment
- 0:55
- Viewed 416 times
-
Respect your right to disconnect with Insights
- 2:26
- Viewed 344 times
-
Change application settings
- 2:53
- Viewed 346 times
-
Manage accessibility settings
- 1:33
- Viewed 512 times
-
Manage privacy settings
- 1:00
- Viewed 355 times
-
Set up and customize your teams
- 2:02
- Viewed 314 times
-
How to add Klaxoon to a current Teams meeting?
- 0:36
- Viewed 347 times
-
How to start a Teams meeting from Klaxoon?
- 1:15
- Viewed 330 times
-
How to integrate Klaxoon directly into a Teams meeting?
- 1:22
- Viewed 349 times
-
Use Microsoft Whiteboard in meetings
- 1:40
- Viewed 388 times
-
Generate a presence report
- 1:23
- Viewed 317 times
-
Generate automatic translations and transcriptions in a meeting
- 1:58
- Viewed 321 times
-
Retrieve items saved in a breakout room
- 0:40
- Viewed 335 times
-
Create, manage and set up a breakout room
- 2:15
- Viewed 499 times
-
Set up breakout rooms before the meeting
- 1:35
- Viewed 366 times
-
Get feedback from your coworkers with Forms questionnaires
- 2:08
- Viewed 343 times
-
Following your activities and your team's activities
- 1:26
- Viewed 321 times
-
Understand the differences between Connectors, Applications and Tabs
- 1:40
- Viewed 326 times
-
Manage team files
- 1:28
- Viewed 341 times
-
Invite external guests
- 1:19
- Viewed 356 times
-
Create private and shared channels
- 1:52
- Viewed 487 times
-
Manage your teams
- 2:38
- Viewed 375 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 488 times
-
Collaborate within a conversation with Microsoft Loop
- 1:34
- Viewed 327 times
-
Store files in conversations
- 1:38
- Viewed 309 times
-
Isolate a conversation window
- 0:50
- Viewed 339 times
-
Use and co-edit files
- 2:06
- Viewed 355 times
-
Exploring Innovation: Applications of Generative AI in Modern Commerce
- 3:25
- Viewed 404 times
-
Optimizing Customer Journeys with AI: A Deep Dive
- 4:39
- Viewed 624 times
-
Deciphering AI-Assisted Marketing: Navigating Personalization, Ethics, and User Engagement in the Digital Age
- 5:34
- Viewed 632 times
-
Generative AI in Marketing : Revolutionize Your Advertising Campaigns
- 4:09
- Viewed 468 times
-
AI in Education : Technology and Innovation in Teacher Training
- 3:31
- Viewed 584 times
-
Shaping the Educational Future : AI, Diversity, Inclusion & Innovative Case Studies
- 3:48
- Viewed 339 times
-
AI and Automated Assessment
- 4:55
- Viewed 436 times
-
AI in Professional and Continuing Education
- 2:26
- Viewed 479 times
-
AI & Education : Technological Innovation Redefining Learning
- 2:23
- Viewed 636 times
-
AI & Education : Interactive Learning and Adaptive Assessment
- 2:55
- Viewed 429 times
-
Educational Revolution : Shaping the Future of Learning with Artificial Intelligence
- 6:39
- Viewed 431 times
-
Deep Dive into NVIDIA Omniverse in 3D Modeling
- 2:25
- Viewed 366 times
-
Advanced Data Analysis with Chat GPT-4 : Unleashing the Power of Data Analysis
- 2:17
- Viewed 352 times
-
Discovering Plugins in Chat GPT-4 : Maximizing Generative AI's Capabilities
- 2:12
- Viewed 423 times
-
Writing with Intelligence : Exploring GPT-4's Capabilities in Generative Writing
- 2:21
- Viewed 441 times
-
Composing with AI : Exploring AIVA and Generative Music
- 2:04
- Viewed 616 times
-
Other Wonders of AI : The Revolution in Image Creation
- 1:19
- Viewed 467 times
-
DALL·E : Turning Words into Artworks
- 1:18
- Viewed 442 times
-
Midjourney : The Symbiosis of Imagination and AI
- 1:32
- Viewed 406 times
-
The Essence of Generative AI in Artistic Creation
- 1:27
- Viewed 473 times
-
Unveiling Prompts : The Evolution and Future of Human-Machine Interaction
- 2:39
- Viewed 419 times
-
Navigating the Neural Forest : Secrets of AI Prompts
- 2:05
- Viewed 395 times
-
Generative AI Prompts : Harnessing the Power of Models
- 3:01
- Viewed 489 times
-
Generative AI in the Digital Space : From Ideation to Presentation
- 2:09
- Viewed 408 times
-
From Data to Discoveries : The Art of Innovation with Generative AI
- 4:38
- Viewed 482 times
-
Keys to Success, Pitfalls to Avoid, and Best Practices
- 2:29
- Viewed 445 times
-
The Impact of AI in the World of Science
- 1:44
- Viewed 491 times
-
Generative AI : Revolution, Efficiency, and Applications in the Modern World
- 1:52
- Viewed 493 times
-
Creative Symbiosis : When Generative AI Shapes Our Future
- 3:46
- Viewed 515 times
-
Generative AI : Between Extreme Personalization and Digital Ethics
- 2:17
- Viewed 516 times
-
Image and Video Manipulation : The Impact of Deepfakes
- 1:51
- Viewed 445 times
-
The Impact of Generative AI on Truth and Trust
- 3:16
- Viewed 474 times
-
Societal Implications of Generative AI
- 5:58
- Viewed 562 times
-
Adaptation Strategies for Organizations and Individuals
- 3:49
- Viewed 484 times
-
History of Generative AI
- 5:27
- Viewed 499 times
-
What is Generative AI ?
- 2:40
- Viewed 560 times
-
Harnessing Advanced Options in Your Loop
- 2:14
- Viewed 310 times
-
Leveraging OneDrive Logic in Your Loop
- 1:01
- Viewed 490 times
-
Transforming Your Section into a Component and Collaborating
- 2:34
- Viewed 226 times
-
Exchange and Communicate Using Discussions in Loop
- 1:14
- Viewed 393 times
-
Search and tag people with “@”
- 2:15
- Viewed 291 times
-
Enhance your pages using the "/" Command
- 3:24
- Viewed 326 times
-
Creating your new workspace
- 1:24
- Viewed 463 times
-
How to Work with the Microsoft Loop Interface?
- 2:36
- Viewed 322 times
-
What is Microsoft Loop ?
- 2:09
- Viewed 374 times
-
View events
- 2:21
- Viewed 482 times
-
Take notes in meetings
- 0:35
- Viewed 431 times
-
Manage a meeting
- 2:08
- Viewed 427 times
-
Start an instant meeting
- 1:33
- Viewed 486 times
-
Join a meeting as a participant
- 2:13
- Viewed 685 times
-
Automatically record a meeting
- 1:12
- Viewed 486 times
-
Presentation of different tools in a meeting
- 1:47
- Viewed 460 times
-
Share content in meetings
- 2:44
- Viewed 408 times
-
Use a background image during a video call
- 1:19
- Viewed 388 times
-
Schedule private or team meetings
- 2:17
- Viewed 516 times
-
Synchronize only one channel
- 0:56
- Viewed 540 times
-
Pin a channel to your favorites
- 1:04
- Viewed 493 times
-
Add channels and tabs
- 1:40
- Viewed 507 times
-
Interact in a conversation
- 2:03
- Viewed 366 times
-
Edit and enhance messages
- 1:57
- Viewed 680 times
-
Create a team using a template
- 1:03
- Viewed 629 times
-
Create a team and add members
- 1:37
- Viewed 574 times
-
Plan a meeting based on a conversation
- 1:28
- Viewed 630 times
-
Interact in conversations
- 1:30
- Viewed 502 times
-
Private and small group chats
- 2:03
- Viewed 437 times
-
Overview of conversations
- 1:02
- Viewed 499 times
-
Define your status message
- 2:13
- Viewed 736 times
-
Customize notifications
- 2:05
- Viewed 531 times
-
Edit photo in Teams
- 0:42
- Viewed 401 times
-
Find content and people
- 0:59
- Viewed 494 times
-
Presentation of the desktop application
- 2:16
- Viewed 404 times
-
Introduction to Teams
- 1:25
- Viewed 392 times
RELATED COURSES This tutorial is part of the following courses
Video Training Microsoft Excel - Intermediate level
Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivot tables, and take advantage of all that Excel has to offer!
- Your trainer for this course
- Cours E-learning
- 727 Views