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
- 1171 views
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 3301 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 3054 times
-
3D Maps
- 1:41
- Viewed 2672 times
-
Manage conditional formatting
- 4:30
- Viewed 2651 times
-
Create a combo chart
- 1:47
- Viewed 2533 times
-
The SUMIF function
- 5:27
- Viewed 2529 times
-
Functions and formulas
- 3:24
- Viewed 2437 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 2420 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 2411 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 2395 times
-
The SUM function
- 4:37
- Viewed 2385 times
-
More complex formulas
- 4:17
- Viewed 2371 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 2369 times
-
Using functions
- 5:12
- Viewed 2366 times
-
Manage drop-down lists
- 6:12
- Viewed 2356 times
-
Advanced formulas and references
- 4:06
- Viewed 2348 times
-
More print options
- 5:59
- Viewed 2346 times
-
Introduction to Excel
- 0:59
- Viewed 2340 times
-
Customize charts
- 4:28
- Viewed 2324 times
-
New Chart types
- 1:52
- Viewed 2321 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2270 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 2266 times
-
Start using Excel
- 4:22
- Viewed 2261 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 2252 times
-
Freeze panes in detail
- 3:30
- Viewed 2252 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2242 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 2236 times
-
AutoFilter details
- 3:27
- Viewed 2235 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 2234 times
-
AutoFill
- 2:55
- Viewed 2227 times
-
Drop-down list settings
- 4:14
- Viewed 2226 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 2216 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2213 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 2209 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 2201 times
-
Look up values on a different worksheet
- 2:39
- Viewed 2197 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 2190 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2184 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 2177 times
-
Header and footer details
- 3:41
- Viewed 2162 times
-
Add numbers
- 2:54
- Viewed 2160 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2157 times
-
Sort details
- 4:46
- Viewed 2147 times
-
Operator order
- 2:04
- Viewed 2146 times
-
A first look at Excel 2016
- 3:22
- Viewed 2146 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 2140 times
-
IF with AND and OR
- 3:35
- Viewed 2138 times
-
Assign a button to a macro
- 2:49
- Viewed 2132 times
-
A closer look at the ribbon
- 3:55
- Viewed 2128 times
-
Work with macros
- 4:40
- Viewed 2120 times
-
Advanced filter details
- 4:13
- Viewed 2111 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 2110 times
-
Print worksheets and workbooks
- 1:07
- Viewed 2109 times
-
Insert columns and rows
- 4:16
- Viewed 2108 times
-
Insert headers and footers
- 2:02
- Viewed 2107 times
-
One click Forecasting
- 1:01
- Viewed 2104 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 2104 times
-
Basic math
- 2:28
- Viewed 2103 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 2101 times
-
Use conditional formatting
- 2:02
- Viewed 2098 times
-
Ink Equation
- 0:41
- Viewed 2084 times
-
AVERAGEIF function
- 3:04
- Viewed 2074 times
-
Save your macro
- 2:59
- Viewed 2070 times
-
Improved version history
- 0:51
- Viewed 2051 times
-
Input and error messages
- 2:52
- Viewed 2048 times
-
Subtract time
- 3:58
- Viewed 2046 times
-
Copy a chart
- 2:59
- Viewed 2044 times
-
Save and print an Excel workbook
- 1:53
- Viewed 2024 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 2021 times
-
Cell references
- 1:34
- Viewed 2020 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 2011 times
-
IFS
- 1:05
- Viewed 1992 times
-
Conditionally format dates
- 2:38
- Viewed 1988 times
-
TEXTJOIN
- 0:47
- Viewed 1987 times
-
Get going fast
- 1:38
- Viewed 1976 times
-
Add formulas and references
- 2:52
- Viewed 1974 times
-
Conditionally format text
- 2:12
- Viewed 1973 times
-
Copying formulas
- 3:00
- Viewed 1972 times
-
Freeze or lock panes
- 1:06
- Viewed 1945 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1942 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1939 times
-
Save, publish, and share
- 2:22
- Viewed 1937 times
-
Weighted average
- 2:06
- Viewed 1919 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1910 times
-
Average a group of numbers
- 2:01
- Viewed 1894 times
-
Use slicers to filter data
- 1:25
- Viewed 1893 times
-
How to create a table
- 2:11
- Viewed 1887 times
-
Share documents
- 1:13
- Viewed 1880 times
-
How things are organized
- 1:58
- Viewed 1874 times
-
Drop-down lists
- 0:55
- Viewed 1871 times
-
Advanced IF functions
- 3:22
- Viewed 1869 times
-
Create a chart
- 0:52
- Viewed 1857 times
-
CONCAT
- 0:51
- Viewed 1840 times
-
Edit a macro
- 3:29
- Viewed 1831 times
-
Flash Fill
- 2:59
- Viewed 1812 times
-
Sort and filter data
- 1:38
- Viewed 1796 times
-
SWITCH
- 1:03
- Viewed 1785 times
-
Nested IF functions
- 3:30
- Viewed 1783 times
-
Page numbers in depth
- 3:06
- Viewed 1759 times
-
Microsoft Search
- 0:34
- Viewed 1757 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1709 times
-
Map Chart in Excel
- 0:31
- Viewed 1702 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 1699 times
-
Funnel Chart
- 0:33
- Viewed 1540 times
-
Accessibility in Excel
- 1:12
- Viewed 1509 times
-
Check Accessibility in Excel
- 1:51
- Viewed 1453 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1198 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1139 times
-
Change chart type
- 1:29
- Viewed 1137 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 1107 times
-
Create dynamic drop down lists
- 3:26
- Viewed 1096 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 5113 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2270 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2242 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2213 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 2166 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
-
Consulting and using a Dashboard
- 3:08
- Viewed 1816 times
-
Improved version history
- 0:51
- 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 1139 times
-
Check and share your form results
- 2:42
- Viewed 1136 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 108 times
-
Customise my SharePoint site navigation
- 2:20
- Viewed 103 times
-
Managing permissions on a SharePoint List
- 1:42
- Viewed 109 times
-
Managing permissions on a SharePoint page
- 1:27
- Viewed 107 times
-
Managing permissions on a SharePoint file
- 1:12
- Viewed 117 times
-
Managing permissions in a SharePoint folder
- 1:10
- Viewed 114 times
-
Managing permissions of a document library
- 2:01
- Viewed 102 times
-
Create a permission group
- 2:11
- Viewed 147 times
-
SharePoint permission levels
- 2:16
- Viewed 106 times
-
Generate a usage report for my SharePoint site
- 1:42
- Viewed 112 times
-
Create a SharePoint news and send it via mail
- 1:59
- Viewed 144 times
-
Create a SharePoint Lists
- 2:18
- Viewed 155 times
-
Create a document library
- 1:56
- Viewed 151 times
-
Create and publish a SharePoint page
- 2:44
- Viewed 159 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 105 times
-
Modify membership to the sites of my organization
- 1:38
- Viewed 110 times
-
Create a SharePoint site
- 1:57
- Viewed 156 times
-
Choose expiration and permissions options for links opened to anyone
- 1:08
- Viewed 101 times
-
Disable the OneDrive sync button
- 0:49
- Viewed 113 times
-
Prevent comments on modern pages
- 1:15
- Viewed 148 times
-
Disable subsite creation
- 0:53
- Viewed 105 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 108 times
-
Access the admin center
- 0:52
- Viewed 152 times
-
Work together on the same document
- 1:48
- Viewed 113 times
-
Create a folder or a file in a library
- 1:46
- Viewed 157 times
-
Synchronise a SharePoint document library
- 1:42
- Viewed 122 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 107 times
-
Share a document to someone outside of my SharePoint site
- 3:57
- Viewed 104 times
-
Use version history
- 1:57
- Viewed 105 times
-
Open and work on a document
- 2:42
- Viewed 108 times
-
Rename and find a document
- 2:00
- Viewed 100 times
-
Create a SharePoint site
- 2:58
- Viewed 162 times
-
Register as a Participant in a Teams Webinar
- 1:05
- Viewed 160 times
-
Add Interactivity to Your Teams Webinar
- 2:02
- Viewed 114 times
-
Ensure Your Webinar Options Before Launching
- 1:09
- Viewed 109 times
-
Prepare Your Webinar with Microsoft Teams
- 3:13
- Viewed 106 times
-
Participate in a Town Hall
- 0:53
- Viewed 101 times
-
End the Event and Gather Statistics
- 1:10
- Viewed 105 times
-
Communicate Behind the Scenes
- 0:56
- Viewed 110 times
-
Moderate the Chat During a Town Hall
- 1:26
- Viewed 105 times
-
Start and Manage Your Event with Multiple People
- 1:20
- Viewed 110 times
-
Start and Manage Your Event Alone
- 1:56
- Viewed 106 times
-
Test Your Event with the Green Room
- 1:52
- Viewed 108 times
-
Plan and Launch a Town Hall
- 2:15
- Viewed 116 times
-
When and Why to Use Town Hall
- 1:38
- Viewed 120 times
-
Differentiate Between Meeting Types
- 1:38
- Viewed 110 times
-
Secure Teams Upon Creation
- 2:57
- Viewed 106 times
-
Apply a Specific Policy to a User
- 1:22
- Viewed 159 times
-
Send an Email to a Team
- 0:38
- Viewed 166 times
-
Analyze Team Dynamics
- 1:19
- Viewed 108 times
-
Create and Send Signatures with Dedicated Services
- 1:46
- Viewed 151 times
-
Create Approval Templates
- 2:06
- Viewed 158 times
-
Manage Document Approval
- 0:56
- Viewed 107 times
-
Make a New Approval Request
- 1:26
- Viewed 154 times
-
Use Templates for Document Creation
- 1:03
- Viewed 111 times
-
Manage Storage Spaces on Teams
- 2:05
- Viewed 108 times
-
Filter Your Document Display
- 1:10
- Viewed 104 times
-
Secure a Shared Document with a Password
- 1:28
- Viewed 113 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 116 times
-
Set Up Monitoring in a Channel with an RSS Feed
- 0:48
- Viewed 109 times
-
Add and Explore Workflows
- 1:35
- Viewed 109 times
-
Use Connectors to Receive Notifications
- 0:48
- Viewed 105 times
-
Manage Privacy in Private Channels
- 2:34
- Viewed 103 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 157 times
-
Use Commands and Keyboard Shortcuts
- 1:29
- Viewed 126 times
-
Customize the Display of the Function Panel
- 0:45
- Viewed 102 times
-
Manage Conversation Options
- 1:35
- Viewed 110 times
-
Use Viva Insights in Conversations
- 0:53
- Viewed 106 times
-
Schedule Message Delivery
- 0:58
- Viewed 147 times
-
Finding Help?
- 0:56
- Viewed 414 times
-
Chancing Your Status
- 0:40
- Viewed 452 times
-
Enabling Mobile Notifications
- 1:28
- Viewed 399 times
-
Enabling Subtitles During a Meeting
- 1:28
- Viewed 459 times
-
Sharing Content in a Meeting
- 0:41
- Viewed 393 times
-
Creating and Joining a Meeting
- 1:22
- Viewed 625 times
-
File Management
- 1:04
- Viewed 414 times
-
Managing Teams and Channels
- 2:15
- Viewed 408 times
-
Posting in a Channel
- 2:15
- Viewed 436 times
-
Creating a Channel
- 2:05
- Viewed 382 times
-
Creating or Joining a Team
- 1:11
- Viewed 614 times
-
Disabling Conversation Notifications
- 0:27
- Viewed 402 times
-
Responding or Reacting to a Message
- 1:01
- Viewed 596 times
-
Starting a Conversation
- 0:53
- Viewed 430 times
-
Searching for Items or People
- 0:30
- Viewed 382 times
-
Interface Overview
- 1:10
- Viewed 458 times
-
Finding and Installing Teams for Mobile
- 0:57
- Viewed 459 times
-
Respect your right to disconnect with Insights
- 2:26
- Viewed 432 times
-
Change application settings
- 2:53
- Viewed 442 times
-
Manage accessibility settings
- 1:33
- Viewed 645 times
-
Manage privacy settings
- 1:00
- Viewed 454 times
-
Set up and customize your teams
- 2:02
- Viewed 396 times
-
How to add Klaxoon to a current Teams meeting?
- 0:36
- Viewed 443 times
-
How to start a Teams meeting from Klaxoon?
- 1:15
- Viewed 409 times
-
How to integrate Klaxoon directly into a Teams meeting?
- 1:22
- Viewed 446 times
-
Use Microsoft Whiteboard in meetings
- 1:40
- Viewed 475 times
-
Generate a presence report
- 1:23
- Viewed 400 times
-
Generate automatic translations and transcriptions in a meeting
- 1:58
- Viewed 408 times
-
Retrieve items saved in a breakout room
- 0:40
- Viewed 417 times
-
Create, manage and set up a breakout room
- 2:15
- Viewed 630 times
-
Set up breakout rooms before the meeting
- 1:35
- Viewed 472 times
-
Get feedback from your coworkers with Forms questionnaires
- 2:08
- Viewed 421 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 451 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 436 times
-
View events
- 2:21
- Viewed 575 times
-
Take notes in meetings
- 0:35
- Viewed 516 times
-
Manage a meeting
- 2:08
- Viewed 523 times
-
Start an instant meeting
- 1:33
- Viewed 588 times
-
Join a meeting as a participant
- 2:13
- Viewed 836 times
-
Automatically record a meeting
- 1:12
- Viewed 589 times
-
Presentation of different tools in a meeting
- 1:47
- Viewed 561 times
-
Share content in meetings
- 2:44
- Viewed 509 times
-
Use a background image during a video call
- 1:19
- Viewed 468 times
-
Schedule private or team meetings
- 2:17
- Viewed 628 times
-
Synchronize only one channel
- 0:56
- Viewed 655 times
-
Pin a channel to your favorites
- 1:04
- Viewed 590 times
-
Add channels and tabs
- 1:40
- Viewed 617 times
-
Interact in a conversation
- 2:03
- Viewed 444 times
-
Edit and enhance messages
- 1:57
- Viewed 823 times
-
Create a team using a template
- 1:03
- Viewed 780 times
-
Create a team and add members
- 1:37
- Viewed 708 times
-
Plan a meeting based on a conversation
- 1:28
- Viewed 744 times
-
Interact in conversations
- 1:30
- Viewed 621 times
-
Private and small group chats
- 2:03
- Viewed 531 times
-
Overview of conversations
- 1:02
- Viewed 592 times
-
Define your status message
- 2:13
- Viewed 901 times
-
Customize notifications
- 2:05
- Viewed 644 times
-
Edit photo in Teams
- 0:42
- Viewed 496 times
-
Find content and people
- 0:59
- Viewed 598 times
-
Presentation of the desktop application
- 2:16
- Viewed 482 times
-
Introduction to Teams
- 1:25
- Viewed 475 times