Guidelines and examples of array formulas - Microsoft Support
An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel for iPhone
Securely browse the web in Microsoft Edge - Microsoft Support
With online threats getting more advanced day by day, it is important to prioritize the safety of your web browsing. Microsoft Edge offers several features and practices that can enhance your online security and protect your personal information.
Share SharePoint files or folders - Microsoft Support
Tip: To quickly share with specific people, you can type in their name or email and then use the pencil icon to the right of the Name, group or email field to select Can edit or Can view.Then follow the same steps below to share with the specific people you listed. For Word documents, you can use the Can review option to let someone add comments and suggestions but prevent them from making edits.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, SharePoint in Microsoft 365 Small Business, SharePoint operated by 21Vianet
Snap your windows - Microsoft Support
The Snap feature is a great way to improve your productivity by sharing many app windows in a single screen. Different layouts are available with many sizes to choose from, so you can get the most from your favorite apps when you are working on specific tasks.
Get new themes and desktop backgrounds - Microsoft Support
Select Start , then select Settings > Personalization > Themes.Choose from a default theme or select Get more themes in Microsoft Store if you want to download new themes with desktop backgrounds that feature cute critters, breathtaking landscapes, and other smile-inducing options.
Sign in to SharePoint - Microsoft Support
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
Device encryption in Windows - Microsoft Support
Is it available on my device? BitLocker encryption is available on supported devices running Windows 10 or 11 Pro, Enterprise, or Education. On supported devices running Windows 10 or newer BitLocker will automatically be turned on the first time you sign into a personal Microsoft account (such as @outlook.com or @hotmail.com) or your work or school account.
Protect yourself from phishing - Microsoft Support
Mismatched email domains- If the email claims to be from a reputable company, like Microsoft or your bank, but the email is being sent from another email domain like Gmail.com, or microsoftsupport.ru it's probably a scam.Also be watchful for very subtle misspellings of the legitimate domain name. Like micros0ft.com where the second "o" has been replaced by a 0, or rnicrosoft.com, where the "m ...
Insert a section break - Microsoft Support
You can add page breaks, but Word for the web can’t add section breaks yet. If you have the Word desktop application, use the Open in Word command to open the document and add section breaks there. When you’re done and you save the document, it will continue to be stored where you opened it in Word for the web.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Access included as part of Microsoft 365 and Office 365 subscriptions
Prior to update. After update. Microsoft 365 Business Standard + Access 2016 Retail (C2R) Both licenses remain on your computer or device. Only one Access 2016 product is shown to you through the user interface.
Applies To: Access for Microsoft 365