FILTER function. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More... The FILTER function allows you to filter a range of data based on criteria you define. 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 ...

So öffnen Sie die PC-Integritätsprüfung. Verwenden Sie in Windows „Suchen“ auf der Taskleiste, um nach „PC-Integritätsprüfung“ zu suchen, und wählen Sie die App dann aus der Ergebnisliste aus. Wenn ein Update für die PC-Integritätsprüfung verfügbar ist, können Sie dieses schnell für die neueste Version installieren. Wenn Sie ...

To add another account to OneDrive on your computer. If you already have a personal OneDrive account set up, you can only add work or school accounts. Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help and Settings icon then Settings .) Go to the Account tab. Select Add an account.

Select the file you want to share on your PC. Right-click on the file and select “ Share .”. Find Phone Link in the App Section of the share pop-up window. File sharing will start on your mobile device connected to Phone Link . Ensure Windows notifications for Phone Link are enabled to monitor the file sharing process in real-time.

You can find efficiency settings in Windows 11 at Settings > System > Power & battery . For a guided walkthrough of how each of the power and battery settings can improve your device's performance, click the button to open the Get Help app: Guided walkthrough in Get Help. Click on each topic below to view some ideas that can improve the power ...

If Windows Update finds an updated driver, it will download and install it, and your printer will automatically use it. If a device driver couldn’t be installed automatically, there may be an optional driver available that your printer can use.

Microsoft Rewards doesn’t ask for a commitment or fees. It's included in your Microsoft account. Make sure you’re logged in, head to the Rewards page, and start exploring. As your points rack up, so do your opportunities to get great rewards. We make it simple to track progress toward anything you’ve got your eye on, including gift cards ...

Open the Camera in Windows. To open up your webcam or camera, select the Start button, then select All apps, and then select Camera in the list of apps. If you have multiple cameras, you can switch between them by selecting Change Camera at the top right once the Camera app is opened. Open Camera.

Manage your Xbox subscription. Game Pass Ultimate or a supported free to play game is required for cloud gaming.

Microsoft support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft Copilot, Microsoft 365, Windows, Surface, and more