FILTER function - Microsoft Support
The FILTER function allows you to filter a range of data based on criteria you define.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Enable or disable macros in Microsoft 365 files
Disable all macros except digitally signed macros Macros are disabled, and security alerts appear if there are unsigned macros present.However, if the macro is digitally signed by a trusted publisher, the macro just runs. If the macro is signed by a publisher you haven't trusted yet, you are given the opportunity to enable the signed macro and trust the publisher.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Visio Professional 2021, Visio Standard 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, Visio Professional 2016, Visio Standard 2016
Block or allow (junk email settings) - Microsoft Support
Safe senders and recipients. Safe senders are people and domains you always want to receive email messages from. Safe recipients are recipients that you don't want to block, usually groups that you’re a member of.
Applies To: Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Cancel a Microsoft 365 subscription - Microsoft Support
Notes: If you don't see an option to Cancel, but instead see a link that says Turn on recurring billing, this means your subscription is already set to expire on the date shown and you won't be automatically charged after this date. There's nothing further to do at this time, and you can continue to use the product until your Microsoft 365 subscription expires.
Fix Wi-Fi connection issues in Windows - Microsoft Support
Things to try first. Try these things first to help you fix or narrow down the connection problem. Run Get Help to troubleshoot and fix common connection problems. Right click the network icon in the right side of the taskbar and select Diagnose network problems or open Get Help for Network & Internet
Find my downloads in Windows 10 - Microsoft Support
To find downloads on your PC: Select File Explorer from the taskbar, or press the Windows logo key + E.
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
Digital signatures and certificates - Microsoft Support
Certificate authority (CA) A certificate authority is an entity similar to a notary public.It issues digital certificates, signs certificates to verify their validity and tracks which certificates have been revoked or have expired.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Visio Professional 2021, Visio Standard 2021, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Visio Professional 2016, Visio Standard 2016
Install Windows 7 Service Pack 1 (SP1) - Microsoft Support
The recommended (and easiest) way to get SP1 is to turn on automatic updating in Windows Update in Control Panel and wait for Windows 7 to notify you that SP1 is ready to install.
Forgotten your Microsoft account username - Microsoft Support
Look up a forgotten username using other information. Look up your username using your security contact phone number or email address. Search