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
How to open Registry Editor in Windows 10 - Microsoft Support
There are two ways to open Registry Editor in Windows 10: In the search box on the taskbar, type regedit, then select Registry Editor (Desktop app) from the results.
Change your profile picture in Microsoft Teams
To change your profile picture in Microsoft Teams, click your existing profile picture and select the camera icon.
Applies To: Microsoft Teams
Focused Inbox for Outlook - Microsoft Support
Turn on Focused Inbox, and move items between Focused and Other folders, Includes instructions for new Outlook, classic Outlook, and the web versions of Outlook.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016
CONCATENATE function - Microsoft Support
Learn how to concatenate text strings in Excel using the CONCATENATE function. Our step-by-step guide makes it easy to join two or more text strings into one.
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
Signing in with a passkey - Microsoft Support
Creating a passkey. To create a passkey for your Microsoft account, follow these steps on the device for which you’d like to create a passkey:
Applies To: Microsoft account dashboard
Ändern oder Zurücksetzen des Kennworts - Microsoft-Support
Erfahren Sie, wie Sie Ihr Windows-Kennwort ändern oder zurücksetzen, wenn Sie es vergessen oder verloren haben.
Create, view, and edit contacts and contact lists in Outlook
Use the People page to create, view, and edit contacts, contact lists, and groups. Create new contacts from scratch, or add someone as a contact from their profile card.
Applies To: Microsoft 365 admin, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016
Create workbook links - Microsoft Support
You can refer to the contents of cells in another workbook by creating an external reference formula. An external reference (also called a link) is a reference to a cell or range on a worksheet in another Excel workbook, or a reference to a defined name in another workbook.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
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 2016