Turn off Defender antivirus protection in Windows Security
Select the Windows Security app from the search results, go to Virus & threat protection, and under Virus & threat protection settings select Manage settings.
FILTER function - Microsoft Support
In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").
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
Stay protected with Windows Security - Microsoft Support
Tip: If you're a Microsoft 365 Family or Personal subscriber you get Microsoft Defender, our advanced security software for Windows, Mac, iOS, and Android, as part of your subscription.Learn more at Getting started with Microsoft Defender.
Create a template - Microsoft Support
Tip: To change where your application automatically saves your templates, click File > Options > Save and type the folder and path you want to use in the Default personal templates location box. Any new templates you save will be stored in that folder, and when you click File > New > Personal, you'll see the templates in that folder.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Word for the web, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Visio Standard 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Visio Standard 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016, Access 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.
Use conditional formatting to highlight information in Excel
Notes: The formatting options that appear in the Formatting tab depend on the data you have selected. If your selection contains only text, then the available options are Text, Duplicate, Unique, Equal To, and Clear.When the selection contains only numbers, or both text and numbers, then the options are Data Bars, Colors, Icon Sets, Greater, Top 10%, and Clear.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Use Microsoft Translator in Microsoft Edge browser
If you open a page written in a different language than your preferred languages in settings, Microsoft Edge will automatically prompt you to translate it. The Translate icon appears in the address bar when you go to a web page that’s written in a foreign language. A language is considered foreign to you if it's not included in your Preferred languages list in Settings.
Applies To: Microsoft Edge
Keyboard shortcuts in Windows - Microsoft Support
Do you want to learn how to navigate Windows using keyboard shortcuts? Whether you need to switch between apps, open the command prompt, or perform any other tasks, you can find a full list of keyboard shortcuts in Windows on this webpage. Discover how to save time and improve your productivity with these handy tips.
COUNTIF function - Microsoft Support
Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.
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
How to use Voice Recorder - Microsoft Support
Voice Recorder is an app for recording lectures, conversations, and other sounds (previously called Sound Recorder). Hit the big Record button (1), and Add a marker (3) to identify key moments as you record or play (2).Then you can Trim (5), Rename (7), or Share your recordings (4), which are saved in Documents > Sound recordings.Select the Delete icon (6) to delete your recording, or See more ...