XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016
Set up the Xbox Wireless Adapter for Windows | Xbox Support
If you're using the adapter on a desktop or other device in which the USB port doesn't face the controller or is blocked by metallic objects, use the included USB extender to avoid wireless interference and maintain a good line of sight to your controller.
Change default programs in Windows - Microsoft Support
To change the default app, you can do either of the following: Set a default for a file type or link type In the search bar, enter the file type or link type you want, then select it from the list of results.
Server settings you'll need from your email provider
Setting. Description. Write Your Setting Here. Example. Host Name. Your incoming mail server name. outlook.office365.com. Username. The email address you want to set up.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Outlook.com, Office 365 operated by 21Vianet - Admin, New Outlook for Windows, Outlook for iOS, Outlook for Windows Phone 10, Outlook Mail for Windows 10, Outlook on the web for Exchange Server 2016
PowerPoint for Windows training - Microsoft Support
Training: Watch and learn how to use PowerPoint in Windows. Explore PowerPoint training guides, articles, and how-to videos.
Applies To: PowerPoint for Microsoft 365, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016, Office for business
Create a PivotTable to analyze worksheet data - Microsoft Support
Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Microsoft account security info & verification codes
You don't need to remove old security information unless there is an account security risk (e.g. someone else has access to your old mailbox). If you do need to replace your security information, make sure you add new information first.
Applies To: Microsoft account dashboard
Create a document - Microsoft Support
Click a template to see a preview. Click the arrows on the side of the preview to see more templates.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
Using the new Bing on the Windows taskbar - Microsoft Support
The new Bing is now available to everybody directly from the Windows taskbar, making more ways to interact with your PC across search, answers, chat, and creation available anytime, right on your desktop.