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
Transcribe your recordings - Microsoft Support
The transcribe feature converts speech to a text transcript with each speaker individually separated. After your conversation, interview, or meeting, you can revisit parts of the recording by playing back the timestamped audio and edit the transcription to make corrections.
Applies To: Word for Microsoft 365, OneNote for Microsoft 365, Word for the web
Change or reset your PIN - Microsoft Support
If you forgot your PIN and need to reset it, you can do so from the Windows sign-in screen. Look below the PIN text box: If you see I forgot my PIN , select it and follow the instructions to reset your PIN.If there are multiple accounts on the device, choose the one you need to reset.
Overview of PivotTables and PivotCharts - Microsoft Support
You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.Each cell in subsequent rows should contain data appropriate to its column heading, and you shouldn't mix data types in the same column.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Set up email in the Mail app - Microsoft Support
Microsoft added OAuth support for Yahoo! accounts in the Windows 10 Creators update. To install the Creators Update now, go to the software download site, and select Update now.For more information about Windows updates, see Get the latest Windows update.. If you have a Japanese Yahoo! email account, you'll need to do the following:
Applies To: Mail for Windows 10, Outlook Mail for Windows 10
Collaborate on Excel workbooks at the same time with co-authoring ...
If you selected the Share button, people will receive an email message inviting them to open the file. They can select the link to open the workbook. A web browser will open, and the workbook will open in Excel for the web. If they want to use the Excel desktop app to co-author, they can select Edit in Desktop App.However, they'll need a version of the Excel app that supports co-authoring.
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 for Windows Phone 10, Excel Mobile
Setup Outlook for iOS and Android - Microsoft Support
Add your email account. Depending on the device you're using, select one of the links below for help on adding your account: Set up email in the Outlook for Android app
Applies To: Outlook for iOS
Export Word documents to PowerPoint presentations
When you use the Export command and select Export to PowerPoint presentation, Word creates a presentation based on all the summarized sections of the document.It also uses AI to add imagery, icons, videos, themes, and fonts for the design theme you choose for the presentation. How it works
Applies To: Word Web App
Create a form with Microsoft Forms - Microsoft Support
Tip: You can also format your text.Highlight a word or words in your title or questions, and then choose any of the following: Bold (keyboard shortcut - CTRL/Cmd+B), Italic (keyboard shortcut - CTRL/Cmd+I), Underline (keyboard shortcut - CTRL/Cmd+U), Font color, Font size, Numbering, or Bullets.
Applies To: Excel for the web, OneNote for the web, OneDrive (work or school), Microsoft Forms
Shipping options, costs, and delivery times - Microsoft Support
The United States Microsoft Store only ships to the U.S. and Puerto Rico. For sales in other countries or regions, visit one of the international Microsoft Stores.. We need a full street address for delivery purposes.