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
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.
Update Windows - Microsoft Support
Learn how to update Windows to ensure your device operates smoothly and securely with the latest features.
Recover lost files on Windows 10 - Microsoft Support
If you can’t locate a lost file from your backup, then you can use Windows File Recovery, which is a command line app available from the Microsoft Store.Use this app to try to recover lost files that have been deleted from your local storage device (including internal drives, external drives, and USB devices) and can’t be restored from the Recycle Bin.
Uninstall Office from a PC - Microsoft Support
Tip: If you installed the Microsoft 365 apps as part of a suite, such as Office Home and Student or Microsoft 365, search for the suite name.For stand-alone apps search by the app name, such as Project or Visio. In most cases you can't uninstall an individual app if it's included in your Microsoft 365 suite.
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
Switch to the new Microsoft Teams - Microsoft Support
When in the new Teams, turn on (or off) notifications by selecting Settings and more at the top of the new Teams, then selecting Settings > Notifications > Open Windows notifications settings.Find Microsoft Teams (work preview) in the apps list and set your preference.
Applies To:
Microsoft Teams
What's new in Office 2021 - Microsoft Support
Immersive Reader advanced color support. In Immersive Reader, we've added many additional ways you can choose a page color.Selecting a page color can make text easy to scan with less eye strain. On the Immersive Reader tab click Page Color to see a 4x5 color picker.. Click More Colors to see additional color selection options such as Wheel, Sliders, Color Palettes, Image Palettes, and Pencils.
Applies To:
Office 2021, Office 2021 for Mac
KB5005463—PC Health Check Application - Microsoft Support
Learn how to download, install, and use the PC Health Check app to check your device's compatibility with Windows 11 and get tips to improve its performance.
How to use Remote Desktop - Microsoft Support
Learn how to use Remote Desktop in Windows. On your Windows, Android, or iOS device: Open the Remote Desktop app (available for free from Microsoft Store, Google Play, and the Mac App Store), and add the name of the PC that you want to connect to (from Step 1). Select the remote PC name that you added, and then wait for the connection to complete.
How to use multiple monitors in Windows - Microsoft Support
Tip: If you're using a wireless display adapter, connect to an HDMI port on newer TVs, then wirelessly connect your PC to it.After connecting your wireless display adapter to your TV, go to your Windows 11 PC, press Windows logo key + K to open Cast, then select your wireless display adapter.