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
How to sign out of your Microsoft account everywhere
If you think someone might have unauthorized access to your account, we can protect you by signing you out from all of your trusted devices. Within 24 hours, you will be signed out of browsers, apps and anywhere else your account is used to sign in, except an Xbox console.
Applies To:
Microsoft account dashboard
Change the refresh rate on your monitor in Windows
Battery Life: Lowering your refresh rate can save battery power by reducing the amount of energy your display consumes.This can be useful when you are using a laptop or tablet and want to extend your battery life.
Change desktop background and colors - Microsoft Support
Select Start > Settings > Personalization.The preview window gives you a sneak peek of your changes as you make them. In Personalize your background, you can select a picture, a solid color, or a slideshow of pictures you create.Or you can choose Windows spotlight to see a new image from around the world every day.
Add an app to run automatically at startup in Windows 10
Right-click the app, select More, and then select Open file location.This opens the location where the shortcut to the app is saved. If there isn't an option for Open file location, it means the app can't run at startup.
So verwenden Sie die App „PC-Integritätsprüfung“
Wenn Sie derzeit Windows 10 verwenden, bietet PC Health Check eine umfassende Eignungsprüfung für Ihr Gerät, um sicherzustellen, dass es die Mindestsystemanforderungen von Windows 11 erfüllt. Sie erhalten Informationen dazu, warum Ihr Gerät geeignet oder nicht geeignet ist, sowie Informationen dazu, was Sie tun können, wenn Ihr Gerät die Anforderungen nicht erfüllt.
Xbox Status | Xbox Support
Check the Xbox services, games, and apps for any service outages.
Clipboard in Windows - Microsoft Support
Copy images and text from one PC to another with a cloud-based clipboard. Not only can you can paste from your clipboard history, but you can also pin the items you find yourself using all the time.
How to use the taskbar in Windows - Microsoft Support
These are the buttons and bars that sit right next to your Start button and cannot be moved.. Search on the taskbar can be set in four ways: either to Search box, which includes a full text box to enter your search (or your Bing Chat prompt; see Using the new Bing on the Windows taskbar for more) into plus additional search highlights, Search icon and label (displaying as a search icon and ...
Phone Link help & learning
Introducing Microsoft Phone Link Our evolution of the former Your Phone app brings a new name to the user experience. With the new Phone Link on your Windows PC and the new Link to Windows app on your Android device, accessing your mobile apps and content has never been easier!