Which Surface devices can be upgraded to Windows 11?
How we're rolling out the free upgrade to Windows 11. The free upgrade to Windows 11 is available based on hardware eligibility, reliability metrics, the age of your Surface, and other factors.
Create a shareable link - Microsoft Support
Training: Learn how to create a shareable link to make it easy to share files in a document, email, or IM.
Applies To: Office for business
Change desktop background and colors - Microsoft Support
Select Start > Settings > Personalization.The preview window gives you a sneak peek of your changes as you make them. In Personalize your background, you can select a picture, a solid color, or a slideshow of pictures you create.Or you can choose Windows spotlight to see a new image from around the world every day.
Manage audio settings in Microsoft Teams meetings
Audio source. When you choose this... Computer audio Your computer's default speaker and mic will be used during the meeting. To adjust your PC mic and speaker settings, select Open device settings .. In Audio settings, select the audio devices you want to use from the Speaker and Microphone dropdown menus.You can alsoturn on spatial audio and adjust noise suppression.
Applies To: Microsoft Teams
SUMIFS function - Microsoft Support
Argument name. Description. Sum_range (required). The range of cells to sum. Criteria_range1 (required). The range that is tested using Criteria1.. Criteria_range1 and Criteria1 set up a search pair whereby a range is searched for specific criteria. Once items in the range are found, their corresponding values in Sum_range are added.. Criteria1 (required)
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
Show desktop icons in Windows - Microsoft Support
Note: If you are in tablet mode, you may not be able to see your desktop icons properly.You can find the program by searching for the program name in File Explorer. To turn off tablet mode, select action center on the taskbar (next to date and time), and then select Tablet mode to turn it on or off.
Change your app recommendation settings in Windows
Go to Settings > Apps > Apps & features to change whether you're shown app recommendations when trying to install apps from outside the Store.
What is a Microsoft account? - Microsoft Support
What is a Microsoft account used for? You need a Microsoft account to sign in to your Windows pc, Xbox console, or any of Microsoft’s products and services, including Office, Outlook.com, OneDrive, Xbox Live, Microsoft 365, Family Safety, Skype, Bing, Microsoft Store and MSN.
Applies To: Microsoft account dashboard
Use AutoSum to sum numbers - Microsoft Support
If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you’re done. When you select AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here’s an example.
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 for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Free up drive space in Windows - Microsoft Support
Note: If it’s been fewer than 10 days since you upgraded to Windows 10, your previous version of Windows will be listed as a system file you can delete.If you need to free up drive space, you can delete it, but keep in mind that you'll be deleting your Windows.old folder, which contains files that give you the option to go back to your previous version of Windows.