COUNTIF function - Microsoft Support
How to use the COUNTIF function in Excel to count the number of cells that meet values you set.
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
Choose between the 64-bit or 32-bit version of Office
Help to decide whether you should install the 32-bit Office version or the 64-bit Office version. Which version is right for you depends on how you plan to use Office. Find out about choosing between 32-bit Office and 64-bit Office.
Applies To:
Office 2021, Office 2019, Office 2016, Microsoft 365 for home, 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, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Open and run DxDiag.exe - Microsoft Support
Learn how to open and run DxDiag.exe on Windows to collect device information and troubleshoot DirectX sound and video issues.
Create a PivotTable to analyze worksheet data - Microsoft Support
How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.
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
Use Snipping Tool to capture screenshots - Microsoft Support
Learn how to use Snipping Tool to capture a screenshot, or snip, of any object on your screen, and then annotate, save, or share the image.
Where to enter your Office product key - Microsoft Support
If your purchase of Office or Microsoft 365 came with a product key, you enter your product key on one of the websites listed below for your product.
Applies To:
Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Office for business
Block or allow (junk email settings) - Microsoft Support
Use the Block or Allow settings in Outlook Web App to help control unwanted and unsolicited email messages.
Applies To:
Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Add or remove a digital signature for Microsoft 365 files
Learn how to use digital signatures, digital IDs, and signature lines in Microsoft 365 files, such as Word, Excel, and PowerPoint.
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Excel 2019, Word 2019, PowerPoint 2019, Excel 2016, Word 2016, PowerPoint 2016
I forgot the account I use with Microsoft 365 - Microsoft Support
Learn how to retrieve a forgotten username or password for your Office for home or Office for business account.
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Excel 2021, Word 2021, Outlook 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, OneNote for Mac, SharePoint in Microsoft 365, Microsoft 365 for home, 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, Microsoft 365 for Mac, Office 365 Activation, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin, Project for Office 365
How to use multiple monitors in Windows - Microsoft Support
Learn how to connect your Windows PC to external monitors and adjust the display settings.