Get productive quickly with Microsoft 365 videos and tutorials. Explore Microsoft 365 training guides and tips to collaborate with anyone, anywhere.

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

Important: If you turn on two-step verification, you will always need two forms of identification.This means that if you forget your password, you need two contact methods. Or if you lose your contact method, your password alone won't get you back into your account—and it can take you 30 days to regain access.

トレーニング: Microsoft の個人、職場または学校のアカウントで Office.com にサインインします。 その方法については、このビデオをご覧ください。

To upgrade to Windows 11, you need enough space on your hard drive for the installation to take place. To view how much hard drive space is available on your computer, select File Explorer on the taskbar (known as Windows Explorer in Windows 7) or press Windows logo key + E. Then select Computer or This PC and look under Hard Disk Drives or under Devices and drives.

These features, including speech recognition, aren't required for voice typing to work. To see this feature's supported languages, see the list in this article. Switch voice typing languages. To switch voice typing languages, you'll need to change the input language you use. Here's how:

Tip: To quickly open the On-screen Keyboard in Windows 11, click the Windows button.Begin typing On-Screen Keyboard which will appear in the search entry box. Under Search, which will appear as a list above the search box, click the On-Screen Keyboard search result. When the on-screen keyboard appears, click the ScrLk button.

Windows share window: Select the Outlook icon in the “Share using” section of the Windows share window to email your files using Outlook directly within the windows share window.It also has a search box. So, you can now search for contacts across Outlook to share a file. The Windows share window also displays 8-10 suggested contacts to quickly share to–including emailing yourself a file.

Using Authenticator as a way to sign in. If you have turned on passwordless, two-step, or multi-factor authentication for your account, use the following steps to sign-in:

On the We need to verify your identity screen, select the security contact method (email address or phone number) where you want us to send your code. Select the option listed to open a dropdown list of all options you have set up on your account. Follow the instructions for completing the contact email address or phone number and select Send code. ...