Seamlessly transfer content between your devices
While you can drag content between your phone and your PC, not all apps will accept content you want to transfer. If an app doesn’t accept your content, you can try using phone screen to transfer it instead. You can’t drag and drop files between your mobile apps from your PC.
Redeem a gift card or code to your Microsoft account
How to redeem a gift card, Xbox download code or token. Both Microsoft and Xbox gift cards and download codes and tokens work the same way: once redeemed to your Microsoft account, you can spend your balance at Microsoft Store online, on Windows or Xbox, and you can get downloads for the latest apps, games, movies, TV shows, and Surface, Xbox ...
Applies To: Microsoft account dashboard
Sign in to SharePoint - Microsoft Support
Go to office.com, and sign in to your work or school account. In the upper left corner of the window, select the app launcher > All apps > SharePoint. Tip: If you don't see the SharePoint app under All apps, use the Search box near the top of the window to search for SharePoint.
Applies To: SharePoint in Microsoft 365
How to use Remote Desktop - Microsoft Support
Use Remote Desktop on your Windows, Android, or iOS device to connect to a Windows 10 PC from afar. Here's how to set up your PC to allow remote connections and then connect to the PC you set up.
Get help with a digital code or gift card | Xbox Support
If you’re unable to read all 25 characters of your digital code, you’ll need to request a replacement code by contacting aka.ms/contactxboxsupport. When you contact support, make sure to provide the proof of purchase, the serial number, and a picture of the damaged code.
How to earn Microsoft Rewards points - Microsoft Support
How to earn Microsoft Rewards points. It’s easy to rack up Microsoft Rewards points and earn your way toward great rewards like gift cards, movies, games, nonprofit donations, and more. Stay signed in with your Microsoft account and you'll earn points for doing the things you already do.
Applies To: Microsoft account dashboard
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH,  are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Enable TPM 2.0 on your PC - Microsoft Support
If you are able to enable a TPM, complete the next step to verify that it is a TPM 2.0. If you see an option for Security processor details under Security processor, select that and verify that your Specification version is 2.0.
App permissions - Microsoft Support
Wired connections: Activate and use any wired connections, including Ethernet, USB, and Serial communications between your device, the internet, and other devices. Learn how to locate and manage your app permissions on Windows devices. Some apps or games need specific permissions to work properly.
Combine text from two or more cells into one cell
Combine data using the CONCAT function. Select the cell where you want to put the combined data. Type =CONCAT (. Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.
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 Mobile