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
Use Snipping Tool to capture screenshots - Microsoft Support
To capture a video snip, open Snipping Tool, select the Record button, then select New recording, or press Windows logo key + Shift + R.Select the area of the screen you wish to record, then select Start.When you are done, select Stop.At this point you can save the recording as-is or select Edit in Clipchamp to work with it in the Clipchamp video editor.
Create and print labels - Microsoft Support
Select Options and choose a label vendor and product to use. Select OK.. If you don’t see your product number, select New Label and configure a custom label.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Troubleshoot the Teams Meeting add-in in Outlook for Windows
The Teams Meeting add-in lets you schedule a Teams meeting from Outlook. The add-in is available for Outlook on Windows, Mac, web, and mobile, and should be automatically installed if you have Microsoft Teams and either Office 2016, Office 2019, or Office 2021 installed on your Windows PC.
Applies To: Outlook 2021, Outlook 2019, Outlook 2016
Start a new line of text inside a cell in Excel - Microsoft Support
To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. Double-click the cell in which you want to insert a line break (or select the cell and then press F2).
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, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Import or export text (.txt or .csv) files - Microsoft Support
Import a text file by opening it in Excel. You can open a text file that you created in another program as an Excel workbook by using the Open command. Opening a text file in Excel does not change the format of the file — you can see this in the Excel title bar, where the name of the file retains the text file name extension (for example, .txt or .csv).
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Manage app permissions for your camera in Windows
To use your camera with apps on Windows 11, you'll need to turn on some permissions in Camera settings. Then, you'll need to check your app permissions if you want to use your camera with apps.
Create films with a video editor - Microsoft Support
For fast and simple editing, we've added Clipchamp as the official Microsoft video editor. Microsoft Clipchamp comes preinstalled on Windows 11 devices. To open Clipchamp, go to the search box on the taskbar, type Clipchamp, and select it from the results.Or you can select Start , then select All apps and scroll down to find Clipchamp in the list of apps.
Use the Microsoft Wireless Display Adapter - Microsoft Support
Plug the USB end of the adapter into a USB charging port on your second display. If your display doesn't have a USB charging port, plug the USB end into any standard USB Type-A charger with 5W (5V/1A).
How to change your Microsoft account name or address
Change display name. You use your display name whenever you sign in to your account. You'll also see it on any Windows devices that you've signed into with your Microsoft Account, and it's the name people see when you send emails or participate in an Outlook.com group.
Applies To: Microsoft account dashboard