An array formula is a formula that can perform multiple calculations on one or more items in an array. You can think of an array as a row or column of values, or a combination of rows and columns of values. Array formulas can return either multiple results, or a single result. Beginning with the September 2018 update for Microsoft 365, any ...

Get support from Microsoft by finding contact options for Canada, including phone numbers and chat sessions.

Select Add email. You can create either a new Outlook.com email address or add an address that you already have. Then, select Add alias. After you’re returned to the previous screen, select Verify, and then follow the instructions that are provided. Or, select Add phone number. Enter the phone number that you want to use, and then select Next.

The DATEVALUE function converts a date that is stored as text to a serial number that Excel recognizes as a date. For example, the formula =DATEVALUE ("1/1/2008") returns 39448, the serial number of the date 1/1/2008. Remember, though, that your computer's system date setting may cause the results of a DATEVALUE function to vary from this example.

Microsoft 365 — including Teams, SharePoint, and OneDrive — is designed to be a universal toolkit to give your team members integrated and flexible ways to work for their projects and tasks. This guide focuses on the powerful capabilities of Teams, SharePoint, and OneDrive, including document storage, collaboration, sharing, and conversations.

Enter a formula that contains a built-in function. Select an empty cell. Type an equal sign = and then type a function. For example, =SUM for getting the total sales. Type an opening parenthesis (. Select the range of cells, and then type a closing parenthesis). Press Enter to get the result.

Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.

A team is a group of people gathered to get something big done in your organization. Sometimes it’s your whole organization. Teams are made up of channels, which are the conversations you have with your teammates. Each channel is dedicated to a specific topic, department, or project. For example, the Mark 8 Project team has General, Design ...

Widget menu (1) – Select the Widget menu icon to open a list of activities to choose from. Mouse click-through (2) – Click-through ensures that all mouse activity will go through a pinned widget and straight to the underlying game or app. Select the mouse icon to enable or disable click-through. Settings (3) – Select the Settings icon to ...

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. If you don't have your key, see get your Workplace ...