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 do I reassign hot keys for my keyboard? - Microsoft Support
Note: The options listed in this wizard vary depending on the key selected.For example, since you cannot reassign the Windows key, the only option available is to disable it.
Update for the new Microsoft Edge for Windows 10, version 1803, 1809 ...
This update is not intended to target Enterprise devices. Specifically, this update targets devices that run Windows 10, version 1803 or later versions that are either Home Edition or Pro Edition.
Edit a PDF - Microsoft Support
To edit a PDF, open it in Word. This works best with PDFs that are mostly text. PDFs of book chapters or something that looks like a manuscript from a copier won't be formatted well in Word.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 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.
Basic tasks in Excel - Microsoft Support
Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
How to use cloud gaming | Xbox Support
See how Xbox cloud gaming works on Android, Apple, and Windows devices, as well as Xbox consoles and Samsung smart TVs.
About delegates: Allow someone to manage your mail and calendar
Similar to having an assistant that helps you manage your incoming paper mail, another person, known as a delegate, can receive and respond to email messages and meeting requests and responses on your behalf.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin, Outlook on the web, New Outlook for Windows
Download languages and voices for Immersive Reader, Read Mode, and Read ...
6. After the new language is installed, navigate to Language and find it in your Preferred languages list. Select your language and choose Options to adjust other language settings, download features, etc. Speech settings and voices. If text-to-speech is available in your language, you can adjust voice settings to change reader voices and speeds when using audible features like Read Aloud in ...
Applies To: OneNote for Microsoft 365, OneNote 2021, Word 2016, OneNote 2016, Immersive Reader
Count how often a value occurs - Microsoft Support
The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)
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