Format a date the way you want - Microsoft Support
When you enter some text into a cell such as "2/2", Excel assumes that this is a date and formats it according to the default date setting in Control Panel.Excel might format it as "2-Feb".If you change your date setting in Control Panel, the default date format in Excel will change accordingly.
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
UNIQUE function - Microsoft Support
Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2. This example has the exactly_once argument set to TRUE, and the function returns only those customers who have had service one time.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Seamlessly transfer content between your devices
Which devices support cross-device copy and paste? Cross-device copy and paste is supported on Surface Duo and Android devices that are running One UI version 2.1 or above or select HONOR devices (1.22036.14.0 or later) or OPPO devices (1.23093.0 or later) or select ASUS devices.
Change the email address or phone number for your Microsoft account
Email addresses and phone numbers associated with your Microsoft account are called aliases and they use the same contacts, online storage, subscriptions, and account settings.
Applies To:
Microsoft account dashboard
Windows Startup Settings (including safe mode) - Microsoft Support
Safe mode starts Windows with a minimal set of drivers and services to help troubleshoot issues. If a problem doesn't reappear when you start your PC in safe mode, you can eliminate the default settings and basic device drivers and services as possible causes.
Fix problems signing in to the Xbox app - Microsoft Support
On your PC, go to Xbox.com and select Sign in.If there are problems with your account, the instructions will help you solve them. If you can’t go beyond the sign-in screen, select Forgot my password and follow the instructions.
Close your Outlook.com account - Microsoft Support
Important: When you close your Microsoft account, your email and contacts are deleted from our servers and can't be recovered.If you use your Microsoft account with Xbox, Skype, OneDrive, or other Microsoft services, you'll no longer be able to access those services.
Applies To:
Outlook.com
Restore deleted files or folders in OneDrive - Microsoft Support
If you accidentally delete a file or folder in OneDrive, you may be able to recover it later from the OneDrive recycle bin.. For info about restoring a SharePoint file or folder, see how to restore items from the SharePoint recycle bin.For info about restoring SharePoint files stored in OneDrive, see Restore a previous version of a file in OneDrive.
Applies To:
OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
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
Protect yourself from tech support scams - Microsoft Support
The classic cold-call scam. The scammers call you and claim to be from the tech support team of Microsoft or another company. They offer to help solve your computer "problems".