Excel - XLOOKUP (Advanced metrics) Video
In this video, you will learn about the intelligent search feature in Microsoft 365. The video covers the search tools in Microsoft 365, including searching on your computer, using Microsoft Search, finding content and people in SharePoint, searching your emails, and more.
This will help you save time and efficiently find documents, information, and even conversations within the Microsoft 365 suite.
Gain valuable insights into the search capabilities of Microsoft 365 and enhance your productivity.
- 9:30
- 1168 views
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 3299 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 3051 times
-
3D Maps
- 1:41
- Viewed 2670 times
-
Manage conditional formatting
- 4:30
- Viewed 2649 times
-
Create a combo chart
- 1:47
- Viewed 2531 times
-
The SUMIF function
- 5:27
- Viewed 2524 times
-
Functions and formulas
- 3:24
- Viewed 2435 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 2416 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 2409 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 2391 times
-
The SUM function
- 4:37
- Viewed 2380 times
-
More complex formulas
- 4:17
- Viewed 2367 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 2367 times
-
Using functions
- 5:12
- Viewed 2362 times
-
Manage drop-down lists
- 6:12
- Viewed 2350 times
-
Advanced formulas and references
- 4:06
- Viewed 2345 times
-
More print options
- 5:59
- Viewed 2344 times
-
Introduction to Excel
- 0:59
- Viewed 2337 times
-
Customize charts
- 4:28
- Viewed 2322 times
-
New Chart types
- 1:52
- Viewed 2317 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2268 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 2261 times
-
Start using Excel
- 4:22
- Viewed 2258 times
-
Freeze panes in detail
- 3:30
- Viewed 2250 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 2247 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2240 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 2232 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 2231 times
-
AutoFilter details
- 3:27
- Viewed 2230 times
-
AutoFill
- 2:55
- Viewed 2225 times
-
Drop-down list settings
- 4:14
- Viewed 2222 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 2212 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2210 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 2207 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 2196 times
-
Look up values on a different worksheet
- 2:39
- Viewed 2193 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 2188 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2182 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 2171 times
-
Header and footer details
- 3:41
- Viewed 2158 times
-
Add numbers
- 2:54
- Viewed 2155 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2155 times
-
Sort details
- 4:46
- Viewed 2144 times
-
Operator order
- 2:04
- Viewed 2141 times
-
A first look at Excel 2016
- 3:22
- Viewed 2141 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 2137 times
-
IF with AND and OR
- 3:35
- Viewed 2136 times
-
Assign a button to a macro
- 2:49
- Viewed 2130 times
-
A closer look at the ribbon
- 3:55
- Viewed 2125 times
-
Work with macros
- 4:40
- Viewed 2118 times
-
Advanced filter details
- 4:13
- Viewed 2109 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 2108 times
-
Insert columns and rows
- 4:16
- Viewed 2106 times
-
Print worksheets and workbooks
- 1:07
- Viewed 2105 times
-
Insert headers and footers
- 2:02
- Viewed 2104 times
-
One click Forecasting
- 1:01
- Viewed 2102 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 2102 times
-
Basic math
- 2:28
- Viewed 2099 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 2099 times
-
Use conditional formatting
- 2:02
- Viewed 2094 times
-
Ink Equation
- 0:41
- Viewed 2082 times
-
AVERAGEIF function
- 3:04
- Viewed 2067 times
-
Save your macro
- 2:59
- Viewed 2066 times
-
Improved version history
- 0:51
- Viewed 2049 times
-
Subtract time
- 3:58
- Viewed 2044 times
-
Input and error messages
- 2:52
- Viewed 2044 times
-
Copy a chart
- 2:59
- Viewed 2041 times
-
Save and print an Excel workbook
- 1:53
- Viewed 2022 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 2019 times
-
Cell references
- 1:34
- Viewed 2017 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 2008 times
-
IFS
- 1:05
- Viewed 1990 times
-
Conditionally format dates
- 2:38
- Viewed 1986 times
-
TEXTJOIN
- 0:47
- Viewed 1985 times
-
Get going fast
- 1:38
- Viewed 1974 times
-
Copying formulas
- 3:00
- Viewed 1970 times
-
Add formulas and references
- 2:52
- Viewed 1969 times
-
Conditionally format text
- 2:12
- Viewed 1967 times
-
Freeze or lock panes
- 1:06
- Viewed 1943 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1939 times
-
Save, publish, and share
- 2:22
- Viewed 1933 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1932 times
-
Weighted average
- 2:06
- Viewed 1917 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1908 times
-
Use slicers to filter data
- 1:25
- Viewed 1891 times
-
Average a group of numbers
- 2:01
- Viewed 1890 times
-
How to create a table
- 2:11
- Viewed 1885 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 1867 times
-
Create a chart
- 0:52
- Viewed 1852 times
-
CONCAT
- 0:51
- Viewed 1838 times
-
Edit a macro
- 3:29
- Viewed 1829 times
-
Flash Fill
- 2:59
- Viewed 1810 times
-
Sort and filter data
- 1:38
- Viewed 1794 times
-
SWITCH
- 1:03
- Viewed 1783 times
-
Nested IF functions
- 3:30
- Viewed 1781 times
-
Microsoft Search
- 0:34
- Viewed 1755 times
-
Page numbers in depth
- 3:06
- Viewed 1754 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1707 times
-
Map Chart in Excel
- 0:31
- Viewed 1697 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 1697 times
-
Funnel Chart
- 0:33
- Viewed 1538 times
-
Accessibility in Excel
- 1:12
- Viewed 1507 times
-
Check Accessibility in Excel
- 1:51
- Viewed 1451 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1198 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1137 times
-
Change chart type
- 1:29
- Viewed 1135 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 1103 times
-
Create dynamic drop down lists
- 3:26
- Viewed 1093 times
-
Text before & after Function
- 4:57
- Viewed 1087 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 1039 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 814 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 2240 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2210 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2182 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 1950 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
-
Manage life cycle of a topic
- 1:44
- Viewed 1147 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1137 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 1039 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 106 times
-
Customise my SharePoint site navigation
- 2:20
- Viewed 101 times
-
Managing permissions on a SharePoint List
- 1:42
- Viewed 107 times
-
Managing permissions on a SharePoint page
- 1:27
- Viewed 104 times
-
Managing permissions on a SharePoint file
- 1:12
- Viewed 115 times
-
Managing permissions in a SharePoint folder
- 1:10
- Viewed 111 times
-
Managing permissions of a document library
- 2:01
- Viewed 100 times
-
Create a permission group
- 2:11
- Viewed 145 times
-
SharePoint permission levels
- 2:16
- Viewed 104 times
-
Generate a usage report for my SharePoint site
- 1:42
- Viewed 109 times
-
Create a SharePoint news and send it via mail
- 1:59
- Viewed 142 times
-
Create a SharePoint Lists
- 2:18
- Viewed 153 times
-
Create a document library
- 1:56
- Viewed 149 times
-
Create and publish a SharePoint page
- 2:44
- Viewed 157 times
-
Customise my site Homepage
- 3:03
- Viewed 109 times
-
Configure the global Theme and logo
- 2:26
- Viewed 155 times
-
Delete a SharePoint site
- 1:12
- Viewed 103 times
-
Modify membership to the sites of my organization
- 1:38
- Viewed 107 times
-
Create a SharePoint site
- 1:57
- Viewed 154 times
-
Choose expiration and permissions options for links opened to anyone
- 1:08
- Viewed 99 times
-
Disable the OneDrive sync button
- 0:49
- Viewed 111 times
-
Prevent comments on modern pages
- 1:15
- Viewed 146 times
-
Disable subsite creation
- 0:53
- Viewed 103 times
-
Set the proper time zone
- 0:44
- Viewed 106 times
-
Define site storage limits
- 1:42
- Viewed 98 times
-
Disable site creation
- 0:52
- Viewed 106 times
-
Access the admin center
- 0:52
- Viewed 150 times
-
Work together on the same document
- 1:48
- Viewed 111 times
-
Create a folder or a file in a library
- 1:46
- Viewed 154 times
-
Synchronise a SharePoint document library
- 1:42
- Viewed 120 times
-
Use the filter pane in a library
- 2:00
- Viewed 105 times
-
Pin a document to the top of a document library
- 1:32
- Viewed 104 times
-
Share a document to someone outside of my SharePoint site
- 3:57
- Viewed 102 times
-
Use version history
- 1:57
- Viewed 103 times
-
Open and work on a document
- 2:42
- Viewed 106 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 158 times
-
Add Interactivity to Your Teams Webinar
- 2:02
- Viewed 112 times
-
Ensure Your Webinar Options Before Launching
- 1:09
- Viewed 107 times
-
Prepare Your Webinar with Microsoft Teams
- 3:13
- Viewed 104 times
-
Participate in a Town Hall
- 0:53
- Viewed 99 times
-
End the Event and Gather Statistics
- 1:10
- Viewed 103 times
-
Communicate Behind the Scenes
- 0:56
- Viewed 108 times
-
Moderate the Chat During a Town Hall
- 1:26
- Viewed 103 times
-
Start and Manage Your Event with Multiple People
- 1:20
- Viewed 107 times
-
Start and Manage Your Event Alone
- 1:56
- Viewed 104 times
-
Test Your Event with the Green Room
- 1:52
- Viewed 106 times
-
Plan and Launch a Town Hall
- 2:15
- Viewed 114 times
-
When and Why to Use Town Hall
- 1:38
- Viewed 119 times
-
Differentiate Between Meeting Types
- 1:38
- Viewed 108 times
-
Secure Teams Upon Creation
- 2:57
- Viewed 103 times
-
Apply a Specific Policy to a User
- 1:22
- Viewed 157 times
-
Send an Email to a Team
- 0:38
- Viewed 162 times
-
Analyze Team Dynamics
- 1:19
- Viewed 106 times
-
Create and Send Signatures with Dedicated Services
- 1:46
- Viewed 149 times
-
Create Approval Templates
- 2:06
- Viewed 155 times
-
Manage Document Approval
- 0:56
- Viewed 105 times
-
Make a New Approval Request
- 1:26
- Viewed 151 times
-
Use Templates for Document Creation
- 1:03
- Viewed 109 times
-
Manage Storage Spaces on Teams
- 2:05
- Viewed 106 times
-
Filter Your Document Display
- 1:10
- Viewed 102 times
-
Secure a Shared Document with a Password
- 1:28
- Viewed 111 times
-
Restrict a Document to Certain Team Members
- 1:50
- Viewed 107 times
-
Restrict a Document to Read-Only
- 0:58
- Viewed 106 times
-
Centralize Important Events in a Single Channel Calendar
- 0:42
- Viewed 112 times
-
Set Up Monitoring in a Channel with an RSS Feed
- 0:48
- Viewed 105 times
-
Add and Explore Workflows
- 1:35
- Viewed 107 times
-
Use Connectors to Receive Notifications
- 0:48
- Viewed 103 times
-
Manage Privacy in Private Channels
- 2:34
- Viewed 100 times
-
Integrate Klaxoon in a Teams Channel
- 0:40
- Viewed 106 times
-
Enable Klaxoon as an App in Teams
- 1:44
- Viewed 107 times
-
Understand and Secure Information Sharing in Instant Messaging
- 2:38
- Viewed 155 times
-
Use Commands and Keyboard Shortcuts
- 1:29
- Viewed 124 times
-
Customize the Display of the Function Panel
- 0:45
- Viewed 100 times
-
Manage Conversation Options
- 1:35
- Viewed 107 times
-
Use Viva Insights in Conversations
- 0:53
- Viewed 104 times
-
Schedule Message Delivery
- 0:58
- Viewed 145 times
-
Finding Help?
- 0:56
- Viewed 412 times
-
Chancing Your Status
- 0:40
- Viewed 450 times
-
Enabling Mobile Notifications
- 1:28
- Viewed 397 times
-
Enabling Subtitles During a Meeting
- 1:28
- Viewed 457 times
-
Sharing Content in a Meeting
- 0:41
- Viewed 390 times
-
Creating and Joining a Meeting
- 1:22
- Viewed 623 times
-
File Management
- 1:04
- Viewed 412 times
-
Managing Teams and Channels
- 2:15
- Viewed 406 times
-
Posting in a Channel
- 2:15
- Viewed 434 times
-
Creating a Channel
- 2:05
- Viewed 379 times
-
Creating or Joining a Team
- 1:11
- Viewed 612 times
-
Disabling Conversation Notifications
- 0:27
- Viewed 400 times
-
Responding or Reacting to a Message
- 1:01
- Viewed 594 times
-
Starting a Conversation
- 0:53
- Viewed 428 times
-
Searching for Items or People
- 0:30
- Viewed 380 times
-
Interface Overview
- 1:10
- Viewed 456 times
-
Finding and Installing Teams for Mobile
- 0:57
- Viewed 456 times
-
Respect your right to disconnect with Insights
- 2:26
- Viewed 430 times
-
Change application settings
- 2:53
- Viewed 439 times
-
Manage accessibility settings
- 1:33
- Viewed 643 times
-
Manage privacy settings
- 1:00
- Viewed 451 times
-
Set up and customize your teams
- 2:02
- Viewed 394 times
-
How to add Klaxoon to a current Teams meeting?
- 0:36
- Viewed 441 times
-
How to start a Teams meeting from Klaxoon?
- 1:15
- Viewed 406 times
-
How to integrate Klaxoon directly into a Teams meeting?
- 1:22
- Viewed 444 times
-
Use Microsoft Whiteboard in meetings
- 1:40
- Viewed 473 times
-
Generate a presence report
- 1:23
- Viewed 398 times
-
Generate automatic translations and transcriptions in a meeting
- 1:58
- Viewed 406 times
-
Retrieve items saved in a breakout room
- 0:40
- Viewed 415 times
-
Create, manage and set up a breakout room
- 2:15
- Viewed 628 times
-
Set up breakout rooms before the meeting
- 1:35
- Viewed 470 times
-
Get feedback from your coworkers with Forms questionnaires
- 2:08
- Viewed 419 times
-
Following your activities and your team's activities
- 1:26
- Viewed 399 times
-
Understand the differences between Connectors, Applications and Tabs
- 1:40
- Viewed 408 times
-
Manage team files
- 1:28
- Viewed 429 times
-
Invite external guests
- 1:19
- Viewed 448 times
-
Create private and shared channels
- 1:52
- Viewed 629 times
-
Manage your teams
- 2:38
- Viewed 460 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 622 times
-
Collaborate within a conversation with Microsoft Loop
- 1:34
- Viewed 409 times
-
Store files in conversations
- 1:38
- Viewed 385 times
-
Isolate a conversation window
- 0:50
- Viewed 419 times
-
Use and co-edit files
- 2:06
- Viewed 434 times
-
View events
- 2:21
- Viewed 573 times
-
Take notes in meetings
- 0:35
- Viewed 514 times
-
Manage a meeting
- 2:08
- Viewed 520 times
-
Start an instant meeting
- 1:33
- Viewed 586 times
-
Join a meeting as a participant
- 2:13
- Viewed 834 times
-
Automatically record a meeting
- 1:12
- Viewed 587 times
-
Presentation of different tools in a meeting
- 1:47
- Viewed 559 times
-
Share content in meetings
- 2:44
- Viewed 507 times
-
Use a background image during a video call
- 1:19
- Viewed 465 times
-
Schedule private or team meetings
- 2:17
- Viewed 626 times
-
Synchronize only one channel
- 0:56
- Viewed 653 times
-
Pin a channel to your favorites
- 1:04
- Viewed 588 times
-
Add channels and tabs
- 1:40
- Viewed 615 times
-
Interact in a conversation
- 2:03
- Viewed 441 times
-
Edit and enhance messages
- 1:57
- Viewed 821 times
-
Create a team using a template
- 1:03
- Viewed 778 times
-
Create a team and add members
- 1:37
- Viewed 705 times
-
Plan a meeting based on a conversation
- 1:28
- Viewed 741 times
-
Interact in conversations
- 1:30
- Viewed 619 times
-
Private and small group chats
- 2:03
- Viewed 528 times
-
Overview of conversations
- 1:02
- Viewed 590 times
-
Define your status message
- 2:13
- Viewed 899 times
-
Customize notifications
- 2:05
- Viewed 641 times
-
Edit photo in Teams
- 0:42
- Viewed 494 times
-
Find content and people
- 0:59
- Viewed 596 times
-
Presentation of the desktop application
- 2:16
- Viewed 481 times
-
Introduction to Teams
- 1:25
- Viewed 473 times