Cooking up a great prompt: Getting the most from Copilot
Prompts are how you ask Copilot for Microsoft 365 to do something for you — like creating, summarizing, editing, or transforming. Think about prompting like having a conversation, using plain but clear language and providing context like you would with an assistant.
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
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
Update Microsoft Teams - Microsoft Support
When an update is available in the Teams desktop app, it'll appear at the top of your Teams window. To update, select Update > Update and restart Teams .. Teams will automatically close and update.
Applies To: Microsoft Teams
OneDrive won't start - Microsoft Support
In order to sync with OneDrive for work or school, the DisableFileSyncNGSC key must be removed or the DWORD value must be changed to 0 (zero). If the registry value was set as part of a Group Policy Object, the policy must be removed.
Applies To: SharePoint in Microsoft 365
Common problems with two-step verification for a work or school account ...
Ensure these modes create an alert that is visible on your device. Make sure you have a device signal and Internet connection. Make sure your phone calls and text messages are getting through to your mobile device.
Control the formatting when you paste text - Microsoft Support
Merge Formatting (M) This option discards most formatting that was applied directly to the copied text, but it retains formatting that is considered emphasis, such as bold and italic, when it is applied to only a portion of the selection.The text takes on the style characteristics of the paragraph where it is pasted. The text also takes on any direct formatting or character style properties of ...
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Word 2013
View live transcription in Microsoft Teams meetings
Important: If your organization is using OneDrive for Business and SharePoint for meeting recordings, the IT admin should turn on Allow transcription in the Teams meeting policy and encourage users to start transcription in every meeting. This will make captions and transcriptions available in post-meeting recordings.
Applies To: Microsoft Teams
Apply sensitivity labels to your files and email - Microsoft Support
You can apply sensitivity labels to your files and emails to keep them compliant with your organization's information protection policies. Sensitivity labels are configured by your administrator and because they're published to users rather than locations such as sites and mailboxes, users in the same organization might see different sensitivity labels to apply.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel for the web, Word for the web, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Outlook on the web, Excel for iPad, Word for iPad, PowerPoint for iPad, Excel for iPhone, Word for iPhone, PowerPoint for iPhone, Word for Android tablets, Excel for Android tablets, PowerPoint for Android tablets, Excel for Android phones, New Outlook for Windows, Outlook for Android, Outlook for iOS, PowerPoint for Android phones, Word for Android phones
"There was a problem when resetting your PC. No changes were made ...
Once that's completed, reboot your system, and attempt to Reset this PC again.