Find and remove duplicates - Microsoft Support
How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
How to use two-step verification with your Microsoft account
Important: If you turn on two-step verification, you will always need two forms of identification.This means that if you forget your password, you need two contact methods. Or if you lose your contact method, your password alone won't get you back into your account—and it can take you 30 days to regain access.
Change privacy settings in Windows - Microsoft Support
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Join a Teams meeting - Microsoft Support
Join a Teams meeting on the web. Don't have the Teams app? You can still join a Teams meeting. In your email invite, select Join the meeting now.. You can also use a dial-in number and conference ID from the email to call in.
Applies To: Microsoft Teams
Recover lost or deleted files - Microsoft Support
If you can't find a file on your computer or you accidently modified or deleted a file, you can restore it from a backup (if you're using Windows backup) or you can try to restore it from a previous version.Previous versions are copies of files and folders that Windows automatically saves as part of a restore point.
Fix microphone problems - Microsoft Support
If you want to give access to desktop apps, make sure that Let desktop apps access your microphone is turned on.You can't turn off microphone access for individual apps. Others can't hear me. Try the following solutions:
Create professional slide layouts with Designer - Microsoft Support
This is a subscriber-only, Microsoft 365 feature. Find your version. Design ideas for one photo Applies to: PowerPoint for Microsoft 365 Current Channel: Version 1511 or later Semi-Annual Enterprise Channel: Version 1602 or later Multiple photos, color extraction, and facial recognition
Applies To: PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint for the web, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016, PowerPoint for iPad, PowerPoint for Android tablets, PowerPoint Mobile
Design the layout and format of a PivotTable - Microsoft Support
To make substantial layout changes to a PivotTable or its various fields, you can use one of three forms: Compact form displays items from different row area fields in one column and uses indentation to distinguish between the items from different fields.Row labels take up less space in compact form, which leaves more room for numeric data.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel 2013
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
Add and request read receipts and delivery notifications in Outlook
A delivery receipt confirms delivery of your email message to the recipient's mailbox, but not that the recipient has seen it or read it. A read receipt confirms that your message was opened.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019