Check your Microsoft warranty and create service orders
Locate the device that you want to check the warranty on, then select Info & support.
SUMIFS function - Microsoft Support
Problem. Description. 0 (Zero) is shown instead of the expected result. Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.. The result is incorrect when Sum_range has TRUE or FALSE values.. TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added. ...
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, Excel Web App
Present your data in a Gantt chart in Excel - Microsoft Support
Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn’t have a predefined Gantt chart type, you can simulate one by customizing a stacked bar chart to show the start and finish dates of tasks, like this:
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Set up an authenticator app as a two-step verification method
Note: If you receive a prompt asking whether to allow the app to access your camera (iOS) or to allow the app to take pictures and record video (Android). select Allow so the authenticator app can access your camera to take a picture of the QR code in the next step.If you don't allow the camera, you can still set up the authenticator app as described in Manually add an account to the app.
Mail merge using an Excel spreadsheet - Microsoft Support
Here are some tips to prepare your Excel spreadsheet for a mail merge. Make sure: Column names in your spreadsheet match the field names you want to insert in your mail merge.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Recall or replace a sent email - Microsoft Support
Note: If you selected Delete unread copies and replace with a new message, the original message opens for editing.When you select Send, the original email message will be deleted from the recipient’s mailbox and replaced with the newly edited one.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016
Windows Media Player - Microsoft Support
Learn how to download, customize, and troubleshoot Windows Media Player 12 with helpful guides and tips.
Join a meeting without an account in Microsoft Teams
Learn how to join a Microsoft Teams meeting if you don't have an account. Join a Teams meeting as a guest in the Windows app or on the web.
Applies To: Microsoft Teams
What do the OneDrive icons mean? - Microsoft Support
The circular arrows over the OneDrive or OneDrive for work or school notification icons signify that sync is in progress. This includes when you are uploading files, or OneDrive is syncing new files from the cloud to your PC.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Get help with Microsoft Photos app - Microsoft Support
Edit photos and videos. Whether you like to apply changes that affect your photo's quality, feel, and look—or you want to add information on top of your photos, the Photos app offers you comprehensive features to transform your photos and videos looking their best.