INDEX function - Microsoft Support
Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Sign in and create multiple profiles in Microsoft Edge
With Edge Chromium, you can add multiple profiles. Profiles allow multiple users to operate in a shared environment while maintaining access to their personalized browser settings, bookmarks, and extensions.
PMT function - Microsoft Support
PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate.. Use the Excel Formula Coach to figure out a monthly loan payment. At the same time, you'll learn how to use the PMT function in a formula. Syntax. PMT(rate, nper, pv, [fv], [type])
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
INDIRECT function - Microsoft Support
Example. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Install the Windows Fax driver or service to use Internet Fax in Office
Microsoft Office has a feature that lets you send Outlook, Word, Excel, and PowerPoint files as Internet faxes. This feature relies on having the Windows Fax Printer Driver or Fax Services installed on the computer to send the faxes.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Word 2021, Word 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Office 2016, Excel 2013, Word 2013, Outlook 2013, PowerPoint 2013, Office 2013
Add people to your family group - Microsoft Support
Notes: If someone is already part of a family group, they must leave or be removed from that group before joining another. They can also create a new Microsoft account to associate with a new family group. Explore Microsoft Family Safety features and benefits.
Applies To: Microsoft Family Safety
Use mail merge for bulk email, letters, labels, and envelopes
Data sources. Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel spreadsheets and Outlook contact lists are the most common data sources, but if you don't yet have a data source, you can type it up in Word, as part of the mail merge process.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016, Word 2016 for Mac
Change the message format to HTML, Rich Text Format, or plain text
You can use RTF when you send messages inside an organization that uses Microsoft Exchange, but we recommend that you use the HTML format. In fact, when you send an RTF message to someone outside your organization, Outlook automatically converts it to HTML, so the message keeps its formatting and its attachments.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
What happens if there's an unusual sign-in to your account
Select Review activity to check for any unusual sign-in attempts on the Recent activity page.If you see account activity that you're sure wasn't yours, let us know and we can help secure your account—if it's in the Unusual activity section, you can expand the activity and select This wasn't me.If it's in the Recent activity section, you can expand the activity and select Secure your account.
Sign in to SharePoint - Microsoft Support
In the upper left corner of the window, select the app launcher > All apps > SharePoint Tip: If you don't see the SharePoint app under All apps, use the Search box near the top of the window to search for SharePoint.
Applies To: SharePoint in Microsoft 365