Excel - XLOOKUP (Basic metrics) Video
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
- 1138 views
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 3300 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 3054 times
-
3D Maps
- 1:41
- Viewed 2671 times
-
Manage conditional formatting
- 4:30
- Viewed 2649 times
-
Create a combo chart
- 1:47
- Viewed 2531 times
-
The SUMIF function
- 5:27
- Viewed 2528 times
-
Functions and formulas
- 3:24
- Viewed 2437 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 2418 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 2411 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 2392 times
-
The SUM function
- 4:37
- Viewed 2382 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 2369 times
-
More complex formulas
- 4:17
- Viewed 2367 times
-
Using functions
- 5:12
- Viewed 2363 times
-
Manage drop-down lists
- 6:12
- Viewed 2353 times
-
Advanced formulas and references
- 4:06
- Viewed 2347 times
-
More print options
- 5:59
- Viewed 2346 times
-
Introduction to Excel
- 0:59
- Viewed 2338 times
-
Customize charts
- 4:28
- Viewed 2323 times
-
New Chart types
- 1:52
- Viewed 2318 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2268 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 2263 times
-
Start using Excel
- 4:22
- Viewed 2260 times
-
Freeze panes in detail
- 3:30
- Viewed 2251 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 2248 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2241 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 2232 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 2232 times
-
AutoFilter details
- 3:27
- Viewed 2231 times
-
AutoFill
- 2:55
- Viewed 2226 times
-
Drop-down list settings
- 4:14
- Viewed 2224 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 2214 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2212 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 2207 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 2199 times
-
Look up values on a different worksheet
- 2:39
- Viewed 2194 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 2189 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2184 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 2172 times
-
Header and footer details
- 3:41
- Viewed 2159 times
-
Add numbers
- 2:54
- Viewed 2156 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2156 times
-
Sort details
- 4:46
- Viewed 2146 times
-
Operator order
- 2:04
- Viewed 2144 times
-
A first look at Excel 2016
- 3:22
- Viewed 2143 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 2138 times
-
IF with AND and OR
- 3:35
- Viewed 2138 times
-
Assign a button to a macro
- 2:49
- Viewed 2130 times
-
A closer look at the ribbon
- 3:55
- Viewed 2126 times
-
Work with macros
- 4:40
- Viewed 2119 times
-
Advanced filter details
- 4:13
- Viewed 2111 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 2109 times
-
Print worksheets and workbooks
- 1:07
- Viewed 2107 times
-
Insert columns and rows
- 4:16
- Viewed 2106 times
-
Insert headers and footers
- 2:02
- Viewed 2105 times
-
One click Forecasting
- 1:01
- Viewed 2103 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 2103 times
-
Basic math
- 2:28
- Viewed 2101 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 2100 times
-
Use conditional formatting
- 2:02
- Viewed 2095 times
-
Ink Equation
- 0:41
- Viewed 2083 times
-
AVERAGEIF function
- 3:04
- Viewed 2068 times
-
Save your macro
- 2:59
- Viewed 2067 times
-
Improved version history
- 0:51
- Viewed 2050 times
-
Input and error messages
- 2:52
- Viewed 2047 times
-
Subtract time
- 3:58
- Viewed 2046 times
-
Copy a chart
- 2:59
- Viewed 2042 times
-
Save and print an Excel workbook
- 1:53
- Viewed 2023 times
-
Cell references
- 1:34
- Viewed 2019 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 2019 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 2011 times
-
IFS
- 1:05
- Viewed 1992 times
-
Conditionally format dates
- 2:38
- Viewed 1987 times
-
TEXTJOIN
- 0:47
- Viewed 1987 times
-
Get going fast
- 1:38
- Viewed 1976 times
-
Copying formulas
- 3:00
- Viewed 1971 times
-
Add formulas and references
- 2:52
- Viewed 1971 times
-
Conditionally format text
- 2:12
- Viewed 1968 times
-
Freeze or lock panes
- 1:06
- Viewed 1945 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1940 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1936 times
-
Save, publish, and share
- 2:22
- Viewed 1935 times
-
Weighted average
- 2:06
- Viewed 1918 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1910 times
-
Average a group of numbers
- 2:01
- Viewed 1892 times
-
Use slicers to filter data
- 1:25
- Viewed 1891 times
-
How to create a table
- 2:11
- Viewed 1886 times
-
Share documents
- 1:13
- Viewed 1878 times
-
How things are organized
- 1:58
- Viewed 1871 times
-
Drop-down lists
- 0:55
- Viewed 1868 times
-
Advanced IF functions
- 3:22
- Viewed 1868 times
-
Create a chart
- 0:52
- Viewed 1853 times
-
CONCAT
- 0:51
- Viewed 1838 times
-
Edit a macro
- 3:29
- Viewed 1830 times
-
Flash Fill
- 2:59
- Viewed 1811 times
-
Sort and filter data
- 1:38
- Viewed 1795 times
-
SWITCH
- 1:03
- Viewed 1784 times
-
Nested IF functions
- 3:30
- Viewed 1783 times
-
Page numbers in depth
- 3:06
- Viewed 1755 times
-
Microsoft Search
- 0:34
- Viewed 1755 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1709 times
-
Map Chart in Excel
- 0:31
- Viewed 1698 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 1697 times
-
Funnel Chart
- 0:33
- Viewed 1540 times
-
Accessibility in Excel
- 1:12
- Viewed 1509 times
-
Check Accessibility in Excel
- 1:51
- Viewed 1452 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1198 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1168 times
-
Change chart type
- 1:29
- Viewed 1137 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 1105 times
-
Create dynamic drop down lists
- 3:26
- Viewed 1095 times
-
Text before & after Function
- 4:57
- Viewed 1089 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 1041 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 816 times
-
Creating a Report
- 2:54
- Viewed 5112 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2268 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2241 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2212 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2184 times
-
Preparing, cleaning and transforming your Data
- 4:42
- Viewed 2173 times
-
Recovering your Data from different sources
- 3:26
- Viewed 2165 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 2008 times
-
Introduction to the Query Editor
- 2:33
- Viewed 1978 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 1973 times
-
Creating your Datasets
- 2:26
- Viewed 1951 times
-
Customising your Visuals
- 2:58
- Viewed 1870 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 1827 times
-
Improved version history
- 0:51
- Viewed 1815 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 1815 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 1723 times
-
Customising your Report
- 3:12
- Viewed 1694 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1168 times
-
Manage life cycle of a topic
- 1:44
- Viewed 1147 times
-
Check and share your form results
- 2:42
- Viewed 1134 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 1041 times
-
Manage video settings
- 1:27
- Viewed 942 times
-
Optimize Meetings with Viva Insights
- 1:58
- Viewed 883 times
-
Analyze your network and communication habits
- 2:17
- Viewed 777 times
-
Receiving a briefing email from Viva Insights
- 0:54
- Viewed 760 times
-
Analyze Team Dynamics
- 1:19
- Viewed 107 times
-
Customise my SharePoint site navigation
- 2:20
- Viewed 102 times
-
Managing permissions on a SharePoint List
- 1:42
- Viewed 107 times
-
Managing permissions on a SharePoint page
- 1:27
- Viewed 105 times
-
Managing permissions on a SharePoint file
- 1:12
- Viewed 116 times
-
Managing permissions in a SharePoint folder
- 1:10
- Viewed 113 times
-
Managing permissions of a document library
- 2:01
- Viewed 100 times
-
Create a permission group
- 2:11
- Viewed 146 times
-
SharePoint permission levels
- 2:16
- Viewed 106 times
-
Generate a usage report for my SharePoint site
- 1:42
- Viewed 110 times
-
Create a SharePoint news and send it via mail
- 1:59
- Viewed 143 times
-
Create a SharePoint Lists
- 2:18
- Viewed 154 times
-
Create a document library
- 1:56
- Viewed 150 times
-
Create and publish a SharePoint page
- 2:44
- Viewed 157 times
-
Customise my site Homepage
- 3:03
- Viewed 111 times
-
Configure the global Theme and logo
- 2:26
- Viewed 157 times
-
Delete a SharePoint site
- 1:12
- Viewed 104 times
-
Modify membership to the sites of my organization
- 1:38
- Viewed 109 times
-
Create a SharePoint site
- 1:57
- Viewed 155 times
-
Choose expiration and permissions options for links opened to anyone
- 1:08
- Viewed 101 times
-
Disable the OneDrive sync button
- 0:49
- Viewed 112 times
-
Prevent comments on modern pages
- 1:15
- Viewed 148 times
-
Disable subsite creation
- 0:53
- Viewed 104 times
-
Set the proper time zone
- 0:44
- Viewed 108 times
-
Define site storage limits
- 1:42
- Viewed 100 times
-
Disable site creation
- 0:52
- Viewed 107 times
-
Access the admin center
- 0:52
- Viewed 152 times
-
Work together on the same document
- 1:48
- Viewed 112 times
-
Create a folder or a file in a library
- 1:46
- Viewed 155 times
-
Synchronise a SharePoint document library
- 1:42
- Viewed 121 times
-
Use the filter pane in a library
- 2:00
- Viewed 107 times
-
Pin a document to the top of a document library
- 1:32
- Viewed 106 times
-
Share a document to someone outside of my SharePoint site
- 3:57
- Viewed 104 times
-
Use version history
- 1:57
- Viewed 104 times
-
Open and work on a document
- 2:42
- Viewed 108 times
-
Rename and find a document
- 2:00
- Viewed 98 times
-
Create a SharePoint site
- 2:58
- Viewed 160 times
-
Register as a Participant in a Teams Webinar
- 1:05
- Viewed 159 times
-
Add Interactivity to Your Teams Webinar
- 2:02
- Viewed 113 times
-
Ensure Your Webinar Options Before Launching
- 1:09
- Viewed 109 times
-
Prepare Your Webinar with Microsoft Teams
- 3:13
- Viewed 105 times
-
Participate in a Town Hall
- 0:53
- Viewed 100 times
-
End the Event and Gather Statistics
- 1:10
- Viewed 104 times
-
Communicate Behind the Scenes
- 0:56
- Viewed 108 times
-
Moderate the Chat During a Town Hall
- 1:26
- Viewed 104 times
-
Start and Manage Your Event with Multiple People
- 1:20
- Viewed 110 times
-
Start and Manage Your Event Alone
- 1:56
- Viewed 105 times
-
Test Your Event with the Green Room
- 1:52
- Viewed 107 times
-
Plan and Launch a Town Hall
- 2:15
- Viewed 115 times
-
When and Why to Use Town Hall
- 1:38
- Viewed 120 times
-
Differentiate Between Meeting Types
- 1:38
- Viewed 108 times
-
Secure Teams Upon Creation
- 2:57
- Viewed 104 times
-
Apply a Specific Policy to a User
- 1:22
- Viewed 157 times
-
Send an Email to a Team
- 0:38
- Viewed 163 times
-
Analyze Team Dynamics
- 1:19
- Viewed 107 times
-
Create and Send Signatures with Dedicated Services
- 1:46
- Viewed 150 times
-
Create Approval Templates
- 2:06
- Viewed 156 times
-
Manage Document Approval
- 0:56
- Viewed 107 times
-
Make a New Approval Request
- 1:26
- Viewed 153 times
-
Use Templates for Document Creation
- 1:03
- Viewed 110 times
-
Manage Storage Spaces on Teams
- 2:05
- Viewed 107 times
-
Filter Your Document Display
- 1:10
- Viewed 104 times
-
Secure a Shared Document with a Password
- 1:28
- Viewed 112 times
-
Restrict a Document to Certain Team Members
- 1:50
- Viewed 109 times
-
Restrict a Document to Read-Only
- 0:58
- Viewed 108 times
-
Centralize Important Events in a Single Channel Calendar
- 0:42
- Viewed 113 times
-
Set Up Monitoring in a Channel with an RSS Feed
- 0:48
- Viewed 107 times
-
Add and Explore Workflows
- 1:35
- Viewed 108 times
-
Use Connectors to Receive Notifications
- 0:48
- Viewed 104 times
-
Manage Privacy in Private Channels
- 2:34
- Viewed 101 times
-
Integrate Klaxoon in a Teams Channel
- 0:40
- Viewed 108 times
-
Enable Klaxoon as an App in Teams
- 1:44
- Viewed 109 times
-
Understand and Secure Information Sharing in Instant Messaging
- 2:38
- Viewed 156 times
-
Use Commands and Keyboard Shortcuts
- 1:29
- Viewed 125 times
-
Customize the Display of the Function Panel
- 0:45
- Viewed 100 times
-
Manage Conversation Options
- 1:35
- Viewed 108 times
-
Use Viva Insights in Conversations
- 0:53
- Viewed 105 times
-
Schedule Message Delivery
- 0:58
- Viewed 146 times
-
Finding Help?
- 0:56
- Viewed 413 times
-
Chancing Your Status
- 0:40
- Viewed 451 times
-
Enabling Mobile Notifications
- 1:28
- Viewed 398 times
-
Enabling Subtitles During a Meeting
- 1:28
- Viewed 458 times
-
Sharing Content in a Meeting
- 0:41
- Viewed 390 times
-
Creating and Joining a Meeting
- 1:22
- Viewed 624 times
-
File Management
- 1:04
- Viewed 414 times
-
Managing Teams and Channels
- 2:15
- Viewed 406 times
-
Posting in a Channel
- 2:15
- Viewed 435 times
-
Creating a Channel
- 2:05
- Viewed 381 times
-
Creating or Joining a Team
- 1:11
- Viewed 613 times
-
Disabling Conversation Notifications
- 0:27
- Viewed 401 times
-
Responding or Reacting to a Message
- 1:01
- Viewed 594 times
-
Starting a Conversation
- 0:53
- Viewed 430 times
-
Searching for Items or People
- 0:30
- Viewed 382 times
-
Interface Overview
- 1:10
- Viewed 457 times
-
Finding and Installing Teams for Mobile
- 0:57
- Viewed 458 times
-
Respect your right to disconnect with Insights
- 2:26
- Viewed 431 times
-
Change application settings
- 2:53
- Viewed 441 times
-
Manage accessibility settings
- 1:33
- Viewed 645 times
-
Manage privacy settings
- 1:00
- Viewed 452 times
-
Set up and customize your teams
- 2:02
- Viewed 395 times
-
How to add Klaxoon to a current Teams meeting?
- 0:36
- Viewed 442 times
-
How to start a Teams meeting from Klaxoon?
- 1:15
- Viewed 407 times
-
How to integrate Klaxoon directly into a Teams meeting?
- 1:22
- Viewed 445 times
-
Use Microsoft Whiteboard in meetings
- 1:40
- Viewed 475 times
-
Generate a presence report
- 1:23
- Viewed 399 times
-
Generate automatic translations and transcriptions in a meeting
- 1:58
- Viewed 407 times
-
Retrieve items saved in a breakout room
- 0:40
- Viewed 417 times
-
Create, manage and set up a breakout room
- 2:15
- Viewed 629 times
-
Set up breakout rooms before the meeting
- 1:35
- Viewed 470 times
-
Get feedback from your coworkers with Forms questionnaires
- 2:08
- Viewed 420 times
-
Following your activities and your team's activities
- 1:26
- Viewed 401 times
-
Understand the differences between Connectors, Applications and Tabs
- 1:40
- Viewed 410 times
-
Manage team files
- 1:28
- Viewed 431 times
-
Invite external guests
- 1:19
- Viewed 450 times
-
Create private and shared channels
- 1:52
- Viewed 631 times
-
Manage your teams
- 2:38
- Viewed 462 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 624 times
-
Collaborate within a conversation with Microsoft Loop
- 1:34
- Viewed 411 times
-
Store files in conversations
- 1:38
- Viewed 387 times
-
Isolate a conversation window
- 0:50
- Viewed 421 times
-
Use and co-edit files
- 2:06
- Viewed 435 times
-
View events
- 2:21
- Viewed 574 times
-
Take notes in meetings
- 0:35
- Viewed 516 times
-
Manage a meeting
- 2:08
- Viewed 522 times
-
Start an instant meeting
- 1:33
- Viewed 587 times
-
Join a meeting as a participant
- 2:13
- Viewed 835 times
-
Automatically record a meeting
- 1:12
- Viewed 587 times
-
Presentation of different tools in a meeting
- 1:47
- Viewed 560 times
-
Share content in meetings
- 2:44
- Viewed 508 times
-
Use a background image during a video call
- 1:19
- Viewed 467 times
-
Schedule private or team meetings
- 2:17
- Viewed 627 times
-
Synchronize only one channel
- 0:56
- Viewed 653 times
-
Pin a channel to your favorites
- 1:04
- Viewed 590 times
-
Add channels and tabs
- 1:40
- Viewed 616 times
-
Interact in a conversation
- 2:03
- Viewed 443 times
-
Edit and enhance messages
- 1:57
- Viewed 823 times
-
Create a team using a template
- 1:03
- Viewed 779 times
-
Create a team and add members
- 1:37
- Viewed 706 times
-
Plan a meeting based on a conversation
- 1:28
- Viewed 743 times
-
Interact in conversations
- 1:30
- Viewed 619 times
-
Private and small group chats
- 2:03
- Viewed 530 times
-
Overview of conversations
- 1:02
- Viewed 591 times
-
Define your status message
- 2:13
- Viewed 900 times
-
Customize notifications
- 2:05
- Viewed 641 times
-
Edit photo in Teams
- 0:42
- Viewed 494 times
-
Find content and people
- 0:59
- Viewed 597 times
-
Presentation of the desktop application
- 2:16
- Viewed 482 times
-
Introduction to Teams
- 1:25
- Viewed 475 times
RELATED COURSES This video 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
- 868 Views