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 ("").

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.

On the General tab, under Home page, enter the URL of the site you want to set as a homepage.You can add more than one URL. Or, to add the site you're currently viewing, select Use current.If you add more than one URL, put each URL on its own line.

Setting up the modem and Internet connection. After you have all the equipment, you'll need to set up your modem and Internet connection. If your modem wasn't set up for you by your Internet service provider (ISP), follow the instructions that came with your modem to connect it to your PC and the Internet.

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.

A phishing email is an email that appears legitimate but is actually an attempt to get your personal information or steal your money. Some deceptive emails appear to be from a safe sender but, in fact, have a "spoofed" source address to fool you.

Learn how to run Windows Update Troubleshooter to resolve errors downloading or installing Windows updates.

Adding Emojis to your conversation. Below the message box are three buttons to help you insert content into your message. The emoji button opens menus where you can quickly search for what you want.

Windows Security provides built-in security options to help protect your device from malicious software attacks. To access the features described below, tap the Windows Start button, type windows security, select it from the results, and then select Device security.

To clear your out of office status and turn off your automatic reply in Teams, return to the Out of Office screen, click the toggle next to Turn on automatic replies and select the Save button. Once you've scheduled an out of office status and message in Teams, you'll see automatic replies turned on in Outlook with the time range and message you set in Teams.