Set up the Xbox Wireless Adapter for Windows | Xbox Support
If you're using the adapter on a desktop or other device in which the USB port doesn't face the controller or is blocked by metallic objects, use the included USB extender to avoid wireless interference and maintain a good line of sight to your controller.
Import Gmail contacts to Outlook - Microsoft Support
After you export your contacts, use Excel to open the CSV file and check that there's data. When you close the file, Excel will prompt you a few times with "are you sure you want to save it in CSV format?"
Applies To: Outlook 2016, Outlook 2013
Get started with OneDrive (work or school) - Microsoft Support
Try it! OneDrive gives you one place to store, share, and sync your work or school files. As part of your organization's Microsoft 365 subscription, or SharePoint Server, you can save your files in OneDrive and then work with them from almost any device.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, OneDrive (work or school), OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Get the latest Windows update - Microsoft Support
Windows devices may get new functionality at different times as Microsoft delivers non-security updates, fixes, improvements, and enhancements via several servicing technologies—including controlled feature rollout (CFR).. Windows will let you know if you need to restart your device to complete an update, and you can choose a time that works best for you to complete that update.
Count unique values among duplicates - Microsoft Support
You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you can use the ROWS function to count the number of items in the new range.. Select the range of cells, or make sure the active cell is in a table. Make sure the range of cells has a column heading.
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
Zip and unzip files - Microsoft Support
Press and hold (or right-click) the file or folder, select (or point to) Send to, and then select Compressed (zipped) folder. A new zipped folder with the same name is created in the same location.
Filter data in a range or table - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Reactivating Windows after a hardware change - Microsoft Support
In Windows 11, it is essential that you link your Microsoft account with the Windows 11 digital license on your device. Linking your Microsoft account with your digital license allows you to reactivate Windows using the Activation troubleshooter whenever you make a significant hardware change.
What's new in Office 2021 - Microsoft Support
Immersive Reader advanced color support. In Immersive Reader, we've added many additional ways you can choose a page color.Selecting a page color can make text easy to scan with less eye strain. On the Immersive Reader tab click Page Color to see a 4x5 color picker.. Click More Colors to see additional color selection options such as Wheel, Sliders, Color Palettes, Image Palettes, and Pencils.
Applies To: Office 2021, Office 2021 for Mac
Stay safe with a genuine Office license - Microsoft Support
Learn how to tell if your Office software is genuine. To help determine if your Microsoft software is genuine, go to our How to Tell site for more information. Here you'll learn about authentic packaging, including what to look for with product key labels, and Certificate of Authenticity (COA), how to report counterfeit software, and find out what your shopping and licensing options are.
Applies To: Office 2019