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
Hotmail にサインインする方法 - Microsoft サポート
Hotmail が Outlook.com になりました。 Hotmail アカウントにサインインするには、[ www.outlook.com] に移動し、[サインイン] を選択 します。 ユーザー名またはパスワードを忘れた場合は、 サインインのトラブルシューティング ツールを使用しますが、2 年以上アカウントにサインインしていない場合は ...
Applies To:
Outlook.com
Install Office updates - Microsoft Support
On a Mac? See Check for Office for Mac updates automatically.. Click here for the Latest updates for versions of Office that use Windows Installer (MSI).. Choose your version of Office. If you're not sure what version of Office you have, see What version of Office am I using?. Not sure which type of install you have?
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, InfoPath 2013, InfoPath Filler 2013
Where to enter your Office product key - Microsoft Support
These steps apply only to Office Professional Plus, Visio Professional, or Project Professional. Step 1: Start an Office app, like Word, Project, or Visio, depending on your purchase.. Step 2: In the Sign in to set up Office window, select I don't want to sign in or create an account (it's a small link at the bottom of the window).. Step 3: Enter your Office product key, without hyphens.
Applies To:
Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Office for business
View your PC info - Microsoft Support
Type about in the search box on your taskbar, and then select About your PC.. View your PC info
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
About the Microsoft Support and Recovery Assistant
Scenario. Description. Recommended Solution. Add Teams meeting add-in for Outlook. Helps fix the issue where teams meeting add-in is missing or is not loaded, preventing you from creating teams meeting from Outlook.
Applies To:
Outlook for Microsoft 365, Office 2021, Office 2019, Office 2016, Microsoft 365 for home, Microsoft 365 admin
Check the recent sign-in activity for your Microsoft account
If you get an email about unusual activity on your Microsoft account, or if you’re worried that someone else might have used your account, go to the Recent activity page.You’ll see when your Microsoft account was signed in during the last 30 days, along with any device or app-specific info.
Applies To:
Microsoft account dashboard
Create a form in Word that users can complete or print
Show the Developer tab. If the developer tab isn't displayed in the ribbon, see Show the Developer tab.. Open a template or use a blank document. To create a form in Word that others can fill out, start with a template or document and add content controls.
Applies To:
Word for Microsoft 365, Word for Microsoft 365 for Mac, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Use Snipping Tool to capture screenshots - Microsoft Support
To capture a video snip, open Snipping Tool, select the Record button, then select New recording, or press Windows logo key + Shift + R.Select the area of the screen you wish to record, then select Start.When you are done, select Stop.At this point you can save the recording as-is or select Edit in Clipchamp to work with it in the Clipchamp video editor.